 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 31 matches |
| Author | Message |
|---|---|
 Topic: Integer to Varchar |
|
| maverick05 Replies: 11 Views: 13774 |
 Forum: Database Posted: Fri Jul 06, 2012 2:34 pm Subject: Integer to Varchar |
| OPTION ZDPRINT
INREC BUILD=(1,12,SFF,TO=ZD,LENGTH=12) SORT FIELDS=(1,12,A),FORMAT=ZD SUM FIELDS=(1,12,ZD) OUTREC FIELDS=(1,12,ZD,EDIT=(SIIIIIIII.IT),SIGNS=(,-) Consider the above as an exa ... |
|
| Topic: Integer to Varchar |
|
| maverick05 Replies: 11 Views: 13774 |
Forum: Database Posted: Fri Jul 06, 2012 2:32 pm Subject: Integer to Varchar |
| maverick05,
Did you try Nascar9 suggestion ? Nascar9 suggestion worked .I somehow missed his message before.Thanks very much Nascar for the solution and Kolusu |
|
| Topic: Integer to Varchar |
|
| maverick05 Replies: 11 Views: 13774 |
Forum: Database Posted: Thu Jul 05, 2012 11:17 am Subject: Integer to Varchar |
| Please do as below:
Step1: Reformat your input file as per the syspunch by using SORT utility. OPTION ZDPRINT INREC BUILD=(1,12,SFF,TO=ZD,LENGTH=12) SORT FIELDS=(1,12,A),FORMAT= ... |
|
| Topic: Integer to Varchar |
|
| maverick05 Replies: 11 Views: 13774 |
Forum: Database Posted: Mon Jul 02, 2012 1:42 pm Subject: Integer to Varchar |
| one of the side benefits of this particular thread is: (wait for it!)
the solution to having a file with fields in a format different than the datatype of the column is learning this scripting l ... |
|
| Topic: Integer to Varchar |
|
| maverick05 Replies: 11 Views: 13774 |
Forum: Database Posted: Thu Jun 28, 2012 12:54 pm Subject: Integer to Varchar |
| Hi,
I have integer variable X data in a flat file from 10-14 positions and 15th is occupied by Null indicator.Now I want to load this data into a DB2 table but X is defined as Varchar(20) nullable. ... |
|
| Topic: Flat files to new PDS members |
|
| maverick05 Replies: 6 Views: 10911 |
Forum: Job Control Language(JCL) Posted: Wed Jun 20, 2012 3:12 pm Subject: Flat files to new PDS members |
| sorry.pardon me again.mod worked for new dataset | |
| Topic: Flat files to new PDS members |
|
| maverick05 Replies: 6 Views: 10911 |
Forum: Job Control Language(JCL) Posted: Wed Jun 20, 2012 3:06 pm Subject: Flat files to new PDS members |
| for 1 file its OK.But I have multiple files and I want to create multiple members in the same PDS.In this case this is not working.Any idea? | |
| Topic: Flat files to new PDS members |
|
| maverick05 Replies: 6 Views: 10911 |
Forum: Job Control Language(JCL) Posted: Wed Jun 20, 2012 2:59 pm Subject: Flat files to new PDS members |
| sorry.never mind.its working fine now.thanks very much | |
| Topic: Flat files to new PDS members |
|
| maverick05 Replies: 6 Views: 10911 |
Forum: Job Control Language(JCL) Posted: Wed Jun 20, 2012 2:54 pm Subject: Flat files to new PDS members |
| Do you have a sample jcl for that? in SYSUT2, I have to define as follows
SYSUT2 DD DSN=datasetname(member),DISP=(,catlg),..... I get the following error MEMBER NAME IS NOT ALLOWED FOR PDSNAME with ... |
|
| Topic: Flat files to new PDS members |
|
| maverick05 Replies: 6 Views: 10911 |
Forum: Job Control Language(JCL) Posted: Wed Jun 20, 2012 2:25 pm Subject: Flat files to new PDS members |
| Hi,
Can you one help me in a JCL which should take flat files as input and put each flat file as a new member of a new/exisiting PDS? Thanks |
|
| Topic: Compression |
|
| maverick05 Replies: 6 Views: 5549 |
Forum: Database Posted: Sun Jun 10, 2012 10:25 pm Subject: Compression |
| nope.Will try and let you know incase of any issues.Just want to get info before I do load | |
| Topic: Compression |
|
| maverick05 Replies: 6 Views: 5549 |
Forum: Database Posted: Thu Jun 07, 2012 10:48 am Subject: Compression |
| well I'm just hoping to get a better answer.I googled compression but didn't get any satisfied answer.I have unloaded a db2 table to a flat file.I'm confused whether I need to decompress the data whil ... | |
| Topic: Compression |
|
| maverick05 Replies: 6 Views: 5549 |
Forum: Database Posted: Thu Jun 07, 2012 9:52 am Subject: Compression |
| Any idea how mainframe flat file compression works? I believe it compresses the data but not the flat file .Suppose if I want to load this flat file to a Db2 table,do I need to decompress the data fla ... | |
| Topic: What is the use of PIC 9.99 over PIC9V99? |
|
| maverick05 Replies: 6 Views: 3984 |
Forum: Application Programming Posted: Sun Oct 03, 2010 7:02 am Subject: What is the use of PIC 9.99 over PIC9V99? |
| Thanks all for the replies. | |
| Topic: What is the use of PIC 9.99 over PIC9V99? |
|
| maverick05 Replies: 6 Views: 3984 |
Forum: Application Programming Posted: Sun Oct 03, 2010 1:04 am Subject: What is the use of PIC 9.99 over PIC9V99? |
| I undersrand the difference.But where exactly this edit mask is used in real-time scenarios? | |
All times are GMT - 5 Hours |