| Author |
Message |
Topic: Removing Leading Zeros. |
aquarian
Replies: 8
Views: 20837
|
Forum: Application Programming Posted: Wed Sep 17, 2014 7:26 am Subject: Removing Leading Zeros. |
Just curious !!
What if the target field is
Z.ZZZ.ZZZ.ZZZ.ZZZ.ZZ9,99-
I did tried it and its moving to right? Is there any way we can move it toleft without hurting the declaration |
Topic: Unload of Data from Db2 table to a Flat file - Decimal value |
aquarian
Replies: 7
Views: 12573
|
Forum: Database Posted: Wed Sep 03, 2014 4:37 am Subject: Unload of Data from Db2 table to a Flat file - Decimal value |
Kolusu
1. I just tried to post across forums assuming to get the solution, will try to keep in mind this in future
2. I am not loading data into Db2, but at receiving end , getting data from a db2 ... |
Topic: Unload of Data from Db2 table to a Flat file - Decimal value |
aquarian
Replies: 7
Views: 12573
|
Forum: Database Posted: Tue Sep 02, 2014 8:59 am Subject: Unload of Data from Db2 table to a Flat file - Decimal value |
No it didnt but actually it gave me an idea !! Thanks for that
I understood sometimes we need to think simple rather than using functions/or any other fancy stuff
Splitting the variables did t ... |
Topic: Unload of Data from Db2 table to a Flat file - Decimal value |
aquarian
Replies: 7
Views: 12573
|
Forum: Database Posted: Tue Sep 02, 2014 2:33 am Subject: Alphanumeric to Display (PACKED) |
It is finalized now, They are giving me data in a file and i need to fetch it, analyze it and display on report
1. Table declaration
X1 DECIMAL (31,2) WITH DEFAULT NULL
2. In the flat f ... |
Topic: Unload of Data from Db2 table to a Flat file - Decimal value |
aquarian
Replies: 7
Views: 12573
|
Forum: Database Posted: Mon Sep 01, 2014 9:25 am Subject: Unload of Data from Db2 table to a Flat file - Decimal value |
Kolusu,
thanks a lot for the reply
I did suggested IFNULL and COALESCE from below link
but the output is not as i expected, My question is is it possible to have the output directly as S9(16) ... |
Topic: Unload of Data from Db2 table to a Flat file - Decimal value |
aquarian
Replies: 7
Views: 12573
|
Forum: Database Posted: Thu Aug 28, 2014 9:51 am Subject: Unload of Data from Db2 table to a Flat file - Decimal value |
Hi,
I have a situation like below
Table
X1 DECIMAL (31,2) WITH DEFAULT NULL
X2 DECIMAL(31,2) NOT NULL WITH DEFAULT
We have a unload job which reads this table and gives a flat file , unfor ... |
Topic: How to Move elements from Endevor to Personal PDS |
aquarian
Replies: 2
Views: 3469
|
Forum: Utilities Posted: Wed Jul 30, 2014 9:03 am Subject: How to Move elements from Endevor to Personal PDS |
| Thanks Kolusu , that helped ! |
Topic: How to Move elements from Endevor to Personal PDS |
aquarian
Replies: 2
Views: 3469
|
Forum: Utilities Posted: Wed Jul 30, 2014 4:54 am Subject: How to Move elements from Endevor to Personal PDS |
Hi,
I am trying to move elements from endevor to Personal PDS, Can some one please let me know how i can do it,
After some google i typed Copyelm , but my shop didnt recognize it, Is there any way ... |
Topic: Data Transfer from TANDEM to Mainframe by NDM process |
aquarian
Replies: 4
Views: 27400
|
Forum: Other Technical Topics Posted: Mon Dec 12, 2011 9:12 am Subject: Data Transfer from TANDEM to Mainframe by NDM process |
I am trying to access this manual couldnt get the below link
http://commerce.csg.stercomm.com/kb/doclibrary/libindex.htm
Has it been changed??? |
Topic: Tandem Mainframes |
aquarian
Replies: 18
Views: 31963
|
Forum: Other Technical Topics Posted: Tue Nov 24, 2009 6:06 am Subject: Tandem Mainframes |
Any recent additions to this thread  |
Topic: How to search a word in a field - Inspect |
aquarian
Replies: 15
Views: 13038
|
Forum: Application Programming Posted: Wed Mar 11, 2009 6:53 am Subject: How to search a word in a field - Inspect |
| This is Awesome!! |
Topic: What is SCOBOL |
aquarian
Replies: 2
Views: 20541
|
Forum: Interview Q & A Posted: Wed Mar 11, 2009 6:15 am Subject: What is SCOBOL |
Scobal means Screen COBOL
Its same as CICS in IBM , you will develop screens and terminal displays using SCOBOL |
Topic: Tandem Mainframes |
aquarian
Replies: 18
Views: 31963
|
Forum: Other Technical Topics Posted: Wed Mar 11, 2009 6:13 am Subject: Tandem Mainframes |
| A simple hi |
Topic: Tandem Mainframes |
aquarian
Replies: 18
Views: 31963
|
Forum: Other Technical Topics Posted: Wed Jan 02, 2008 5:55 pm Subject: Tandem Mainframes |
| Any folks working on Tandem |
Topic: Cursor in cobol |
aquarian
Replies: 12
Views: 7686
|
Forum: Application Programming Posted: Mon Aug 13, 2007 4:51 am Subject: Cursor in cobol |
Seems some serious issue here  |
| |