Tags » Jm

End day 2 or really the beginning of day 3

So I stayed up finishing The Pearl and now that I’m done I want to read it again. It is a very interesting read that everyone can relate to, in how we will always want for more then what we have, and how we can become attached to materialistic items. 22 more words

JM

End of Day 1 JM

at the end of the first day i have completed 50 pages and half of my first book The Pearl by John Steinbeck, so far i have really enjoyed this intriguing story.

JM

JM: The Story So Far

JM is short hand for the pen name James Moran, created by me, J Ferrara. James Moran is a more modern version of James Moriarty, one of the most remarkable villains in any literary universe. 299 more words

JM

JM's Picks

Goal: 10 books (page count> 1495)
List to Date
1. Once There Was a War, Steinbeck, John.
2. Babylon Revisited, Fitzgerald, F. Scott.
3. Men Without Women, Hemingway, Ernest… 16 more words

JM

I Am A Hypocrite, JM Is And So Are You!

In 2004, I made a decision to dig into the life of Author and multi-talented Poet Maya Angelou.

I took interest in Maya because I had an interest in the life of anybody who had played a role in the liberation of our race; she was one of them. 1,298 more words

GHANA

convert/simplify sql statement

Good day everyone!
I was trying to convert this db2 code into sql:

CREATE VIEW TBSDB2P.V_ADVICE_SLIPS as select * from ( select AS.AS_NUMBER,AS.CREATE_TIME_STAMP, AS.ORIGINAL_AS_NUMBER, AS.Record_Status, AS.Approval_Status, AS.Transaction_Type, AS.Value_Date, AS.ASSET_CLASS_CODE, ACCT.ACCOUNT_NUMBER, ACCT.ACCOUNT_NAME, DEP.TENOR, nullif(0,0) Price_Per_100, DEP.FACE_VALUE, nullif(0,0) Number_of_shares, nullif(0,0) Price_per_share, AS.SETTLEMENT_AMOUNT, DEP.RATE, nullif(0,0) YTM, AS.ISSUE_CODE, ACCT.USER_ID as ACCOUNT_OFFICER, AS.ACCOUNT_OFFICER as MAKER, ACCT.ARRANGEMENT, ACCT.PRODUCT_CODE, ACCT.TBG_UNIT_CODE, ACCT.BANK_BRANCH_UNIT_CODE, BANK.REGION_ID, AS.COUNTER_PARTY_CODE, AS.COUNTER_PARTY_CODE as ISSUER_CODE, AS.AS_TYPE, AS.REQ_TBG_UNIT_ID FROM TBSDB2P.IMS_AS AS INNER JOIN TBSDB2P.IMS_AS_DEPOSIT DEP on (AS.AS_NUMBER = DEP.AS_NUMBER) LEFT JOIN TBSDB2P.IMS_AS_ALLOCATION ALLOC on ( DEP.as_number = ALLOC.as_number ) LEFT JOIN TBSDB2P.AMS_ACCOUNT ACCT on (ALLOC.Account_number = ACCT.ACCOUNT_NUMBER) LEFT JOIN TBSDB2P.TBS_BANK_BRANCH_UNIT BANK on ( ACCT.BANK_BRANCH_UNIT_CODE = BANK.BANK_BRANCH_UNIT_CODE ) LEFT JOIN TBSDB2P.TBS_ISSUE ISSUE on (AS.ISSUE_CODE = ISSUE.ISSUE_CODE) UNION ALL select AS.AS_NUMBER, AS.CREATE_TIME_STAMP, AS.ORIGINAL_AS_NUMBER, AS.Record_Status, AS.Approval_Status, AS.Transaction_Type, AS.Value_Date, AS.ASSET_CLASS_CODE, ACCT.ACCOUNT_NUMBER, ACCT.ACCOUNT_NAME, nullif(0,0) TENOR, nullif(0,0) Price_Per_100, nullif(0,0) FACE_VALUE, EQT.AWARDED_NUMBER_OF_SHARES, EQT.Price_per_share, AS.SETTLEMENT_AMOUNT, nullif(0,0) RATE, nullif(0,0) YTM, AS.ISSUE_CODE, ACCT.USER_ID as ACCOUNT_OFFICER, AS.ACCOUNT_OFFICER as MAKER, ACCT.ARRANGEMENT, ACCT.PRODUCT_CODE, ACCT.TBG_UNIT_CODE, ACCT.BANK_BRANCH_UNIT_CODE, BANK.REGION_ID, AS.COUNTER_PARTY_CODE, ISSUE.ENTITY_CODE as ISSUER_CODE, AS.AS_TYPE, AS.REQ_TBG_UNIT_ID FROM TBSDB2P.IMS_AS AS INNER JOIN TBSDB2P.IMS_AS_EQUITY EQT on (AS.AS_NUMBER = EQT.AS_NUMBER) LEFT JOIN TBSDB2P.IMS_AS_ALLOCATION ALLOC on ( AS.as_number = ALLOC.as_number ) LEFT JOIN TBSDB2P.AMS_ACCOUNT ACCT on (ALLOC.Account_number = ACCT.ACCOUNT_NUMBER) LEFT JOIN TBSDB2P.TBS_BANK_BRANCH_UNIT BANK on ( ACCT.BANK_BRANCH_UNIT_CODE = BANK.BANK_BRANCH_UNIT_CODE ) LEFT JOIN TBSDB2P.TBS_ISSUE ISSUE on (AS.ISSUE_CODE = ISSUE.ISSUE_CODE) UNION ALL select AS.AS_NUMBER, AS.CREATE_TIME_STAMP, AS.ORIGINAL_AS_NUMBER, AS.Record_Status, AS.Approval_Status, AS.Transaction_Type, AS.Value_Date, AS.ASSET_CLASS_CODE, ACCT.ACCOUNT_NUMBER, ACCT.ACCOUNT_NAME, nullif(0,0) TENOR, GS.Price_Per_100, GS.AWARDED_FACE_VALUE as FACE_VALUE, nullif(0,0) Number_of_shares, nullif(0,0) Price_per_share, AS.SETTLEMENT_AMOUNT, nullif(0,0) RATE, GS.YTM, AS.ISSUE_CODE, ACCT.USER_ID as ACCOUNT_OFFICER, AS.ACCOUNT_OFFICER as MAKER, ACCT.ARRANGEMENT, ACCT.PRODUCT_CODE, ACCT.TBG_UNIT_CODE, ACCT.BANK_BRANCH_UNIT_CODE, BANK.REGION_ID, AS.COUNTER_PARTY_CODE, ISSUE.ENTITY_CODE as ISSUER_CODE, AS.AS_TYPE, AS.REQ_TBG_UNIT_ID FROM TBSDB2P.IMS_AS AS INNER JOIN TBSDB2P.IMS_AS_GS GS on (AS.AS_NUMBER = GS.AS_NUMBER) LEFT JOIN TBSDB2P.IMS_AS_ALLOCATION ALLOC on ( AS.as_number = ALLOC.as_number ) LEFT JOIN TBSDB2P.AMS_ACCOUNT ACCT on (ALLOC.Account_number = ACCT.ACCOUNT_NUMBER) LEFT JOIN TBSDB2P.TBS_BANK_BRANCH_UNIT BANK on ( ACCT.BANK_BRANCH_UNIT_CODE = BANK.BANK_BRANCH_UNIT_CODE ) LEFT JOIN TBSDB2P.TBS_ISSUE ISSUE on (AS.ISSUE_CODE = ISSUE.ISSUE_CODE) UNION ALL select AS.AS_NUMBER, AS.CREATE_TIME_STAMP, AS.ORIGINAL_AS_NUMBER, AS.Record_Status, AS.Approval_Status, AS.Transaction_Type, AS.Value_Date, AS.ASSET_CLASS_CODE, ACCT.ACCOUNT_NUMBER, ACCT.ACCOUNT_NAME, nullif(0,0) TENOR, nullif(0,0) Price_Per_100, PREF.FACE_VALUE, PREF.DONE_NUMBER_OF_SHARES, PREF.Price_per_share, AS.SETTLEMENT_AMOUNT, nullif(0,0) RATE, PREF.YTM, AS.ISSUE_CODE, ACCT.USER_ID as ACCOUNT_OFFICER, AS.ACCOUNT_OFFICER as MAKER, ACCT.ARRANGEMENT, ACCT.PRODUCT_CODE, ACCT.TBG_UNIT_CODE, ACCT.BANK_BRANCH_UNIT_CODE, BANK.REGION_ID, AS.COUNTER_PARTY_CODE, ISSUE.ENTITY_CODE as ISSUER_CODE, AS.AS_TYPE, AS.REQ_TBG_UNIT_ID FROM TBSDB2P.IMS_AS AS INNER JOIN TBSDB2P.IMS_AS_PREF PREF on ( AS.AS_NUMBER = PREF.AS_NUMBER ) LEFT JOIN TBSDB2P.IMS_AS_ALLOCATION ALLOC on ( AS.as_number = ALLOC.as_number ) LEFT JOIN TBSDB2P.AMS_ACCOUNT ACCT on (ALLOC.Account_number = ACCT.ACCOUNT_NUMBER) LEFT JOIN TBSDB2P.TBS_BANK_BRANCH_UNIT BANK on ( ACCT.BANK_BRANCH_UNIT_CODE = BANK.BANK_BRANCH_UNIT_CODE ) LEFT JOIN TBSDB2P.TBS_ISSUE ISSUE on (AS.ISSUE_CODE = ISSUE.ISSUE_CODE) UNION ALL select AS.AS_NUMBER, AS.CREATE_TIME_STAMP, AS.ORIGINAL_AS_NUMBER, AS.Record_Status, AS.Approval_Status, AS.Transaction_Type, AS.Value_Date, AS.ASSET_CLASS_CODE, ACCT.ACCOUNT_NUMBER, ACCT.ACCOUNT_NAME, nullif(0,0) TENOR, nullif(0,0) Price_Per_100, PREP.FACE_VALUE, PREP.AWARDED_NUMBER_OF_SHARES, PREP.Price_per_share, AS.SETTLEMENT_AMOUNT, nullif(0,0) RATE, nullif(0,0) YTM, AS.ISSUE_CODE, ACCT.USER_ID as ACCOUNT_OFFICER, AS.ACCOUNT_OFFICER as MAKER, ACCT.ARRANGEMENT, ACCT.PRODUCT_CODE, ACCT.TBG_UNIT_CODE, ACCT.BANK_BRANCH_UNIT_CODE, BANK.REGION_ID, AS.COUNTER_PARTY_CODE, ISSUE.ENTITY_CODE as ISSUER_CODE, AS.AS_TYPE, AS.REQ_TBG_UNIT_ID FROM TBSDB2P.IMS_AS AS INNER JOIN TBSDB2P.IMS_AS_PREP PREP on ( AS.AS_NUMBER = PREP.AS_NUMBER ) LEFT JOIN TBSDB2P.IMS_AS_ALLOCATION ALLOC on ( AS.as_number = ALLOC.as_number ) LEFT JOIN TBSDB2P.AMS_ACCOUNT ACCT on (ALLOC.Account_number = ACCT.ACCOUNT_NUMBER) LEFT JOIN TBSDB2P.TBS_BANK_BRANCH_UNIT BANK on ( ACCT.BANK_BRANCH_UNIT_CODE = BANK.BANK_BRANCH_UNIT_CODE ) LEFT JOIN TBSDB2P.TBS_ISSUE ISSUE on (AS.ISSUE_CODE = ISSUE.ISSUE_CODE) UNION ALL select AS.AS_NUMBER, AS.CREATE_TIME_STAMP, AS.ORIGINAL_AS_NUMBER, AS.Record_Status, AS.Approval_Status, AS.Transaction_Type, AS.Value_Date, AS.ASSET_CLASS_CODE, ACCT.ACCOUNT_NUMBER, ACCT.ACCOUNT_NAME, nullif(0,0) TENOR, OSEC.Price_Per_100, OSEC.AWARDED_FACE_VALUE as  FACE_VALUE, nullif(0,0) Number_of_shares, nullif(0,0) Price_per_share, AS.SETTLEMENT_AMOUNT, nullif(0,0) RATE, OSEC.YTM, AS.ISSUE_CODE, ACCT.USER_ID as ACCOUNT_OFFICER, AS.ACCOUNT_OFFICER as MAKER, ACCT.ARRANGEMENT, ACCT.PRODUCT_CODE, ACCT.TBG_UNIT_CODE, ACCT.BANK_BRANCH_UNIT_CODE, BANK.REGION_ID, AS.COUNTER_PARTY_CODE, ISSUE.ENTITY_CODE as ISSUER_CODE, AS.AS_TYPE, AS.REQ_TBG_UNIT_ID FROM TBSDB2P.IMS_AS AS INNER JOIN TBSDB2P.IMS_AS_OSEC OSEC on ( AS.AS_NUMBER = OSEC.AS_NUMBER ) LEFT JOIN TBSDB2P.IMS_AS_ALLOCATION ALLOC on ( AS.as_number = ALLOC.as_number ) LEFT JOIN TBSDB2P.AMS_ACCOUNT ACCT on (ALLOC.Account_number = ACCT.ACCOUNT_NUMBER) LEFT JOIN TBSDB2P.TBS_BANK_BRANCH_UNIT BANK on ( ACCT.BANK_BRANCH_UNIT_CODE = BANK.BANK_BRANCH_UNIT_CODE ) LEFT JOIN TBSDB2P.TBS_ISSUE ISSUE on (AS.ISSUE_CODE = ISSUE.ISSUE_CODE) UNION ALL select AS.AS_NUMBER, AS.CREATE_TIME_STAMP, AS.ORIGINAL_AS_NUMBER, AS.Record_Status, AS.Approval_Status, AS.Transaction_Type, AS.Value_Date, AS.ASSET_CLASS_CODE, ACCT.ACCOUNT_NUMBER, ACCT.ACCOUNT_NAME, nullif(0,0) TENOR, nullif(0,0) Price_Per_100, nullif(0,0) FACE_VALUE, PF.AWARDED_NUMBER_OF_UNITS as number_of_shares, nullif(0,0) Price_per_share, AS.SETTLEMENT_AMOUNT, nullif(0,0) RATE, nullif(0,0) YTM, AS.ISSUE_CODE, ACCT.USER_ID as ACCOUNT_OFFICER, AS.ACCOUNT_OFFICER as MAKER, ACCT.ARRANGEMENT, ACCT.PRODUCT_CODE, ACCT.TBG_UNIT_CODE, ACCT.BANK_BRANCH_UNIT_CODE, BANK.REGION_ID, AS.COUNTER_PARTY_CODE, ISSUE.ENTITY_CODE as ISSUER_CODE, AS.AS_TYPE, AS.REQ_TBG_UNIT_ID FROM TBSDB2P.IMS_AS AS INNER JOIN TBSDB2P.IMS_AS_POOLED_FUNDS PF on (AS.AS_NUMBER = PF.AS_NUMBER) LEFT JOIN TBSDB2P.IMS_AS_ALLOCATION ALLOC on ( AS.as_number = ALLOC.as_number ) LEFT JOIN TBSDB2P.AMS_ACCOUNT ACCT on (ALLOC.Account_number = ACCT.ACCOUNT_NUMBER) LEFT JOIN TBSDB2P.TBS_BANK_BRANCH_UNIT BANK on ( ACCT.BANK_BRANCH_UNIT_CODE = BANK.BANK_BRANCH_UNIT_CODE ) LEFT JOIN TBSDB2P.TBS_ISSUE ISSUE on (AS.ISSUE_CODE = ISSUE.ISSUE_CODE) ) as ALL_AS;
… 1,412 more words
Recent Questions - Stack Overflow

Муҳокама:

Нега ўзбекнинг боласи

адашиб Сурияга бормоқда?

https://jahon.files.wordpress.com/2014/11/ozodlik_suriyaga.mp3

1.BOSH SAHIFA