MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 63 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Removing Leading Zeros.
aquarian

Replies: 8
Views: 20837

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: Other Technical Topics   Posted: Tue Nov 24, 2009 6:06 am   Subject: Tandem Mainframes
Any recent additions to this thread bonk
  Topic: How to search a word in a field - Inspect
aquarian

Replies: 15
Views: 13038

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: Application Programming   Posted: Mon Aug 13, 2007 4:51 am   Subject: Cursor in cobol
Seems some serious issue here Smile
 
Page 1 of 5 Goto page 1, 2, 3, 4, 5  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group