Author |
Message |
Topic: Adding 2 columns to a DB2 table |
manesh
Replies: 2
Views: 3713
|
Forum: Database Posted: Tue Mar 03, 2009 3:32 am Subject: Adding 2 columns to a DB2 table |
Hi
I am able to add one column to the db2 table using ALTER as shown below,
ALTER TABLE TABLE_NAME
ADD NEW_CLOUMN_NAME1 DECIMAL(11,2)
When I am trying to ADD 2 columns ... |
Topic: Inspect a field and extract using Outrec in ICETOOL/Sort |
manesh
Replies: 5
Views: 3119
|
Forum: Utilities Posted: Tue Feb 12, 2008 11:08 am Subject: Inspect a field and extract using Outrec in ICETOOL/Sort |
Kolusu,
Thanks for your support.
I can also use SAS or EASYTRIEVE.
Please help me solving this using SAS or EASYTRIEVE.
Starting position of field is 13 and length is 20.
Regards,
Ma ... |
Topic: Inspect a field and extract using Outrec in ICETOOL/Sort |
manesh
Replies: 5
Views: 3119
|
Forum: Utilities Posted: Mon Feb 11, 2008 5:40 pm Subject: Inspect a field and extract using Outrec in ICETOOL/Sort |
Kolusu,
Thanks a Lot for your reply.
I am getting following error,
SYNCSORT FOR Z/OS 1.1BR TPF2B U.S. PATENTS: 4210961, 5117
z/OS ... |
Topic: Inspect a field and extract using Outrec in ICETOOL/Sort |
manesh
Replies: 5
Views: 3119
|
Forum: Utilities Posted: Mon Feb 11, 2008 4:49 pm Subject: Inspect a field and extract using Outrec in ICETOOL/Sort |
Hi,
I have have field in the file starting at 100 with length 30.I need to inspect each byte for space and extract till that point (Space) using Outrec.
INPUT
xxxxxxxxxxx xxxxxxx
Output sh ... |
Topic: solve my FTP problem |
manesh
Replies: 9
Views: 26599
|
Forum: Job Control Language(JCL) Posted: Wed Sep 06, 2006 12:02 am Subject: solve my FTP problem |
blocksizes of 2 files??well that is my friend's code..and maybe my friend is storing a image in those 2 files......
and my FTP jcl is working...i gave ip,userid and password in a file and giving th ... |
Topic: solve my FTP problem |
manesh
Replies: 9
Views: 26599
|
Forum: Job Control Language(JCL) Posted: Fri Sep 01, 2006 7:06 am Subject: solve my FTP problem |
hi kolusu...... i tried that also...it is not comingggg |
Topic: solve my FTP problem |
manesh
Replies: 9
Views: 26599
|
Forum: Job Control Language(JCL) Posted: Tue Aug 29, 2006 12:53 am Subject: solve my FTP problem |
today when i submitted my job this is messages i got in output...
EZA1450I IBM FTP CS V1R4
EZA1456I Connect to ? ... |
Topic: solve my FTP problem |
manesh
Replies: 9
Views: 26599
|
Forum: Job Control Language(JCL) Posted: Mon Aug 28, 2006 11:35 am Subject: solve my FTP problem |
//G54574J JOB ,,NOTIFY=&SYSUID,CLASS=B,MSGLEVEL=(1,1),MSGCLASS=X
//STEP1 EXEC PGM=EZACFSM1
//SYSIN DD * ... |
Topic: Im getting MAXCC=0,but not able to FTP the file |
manesh
Replies: 4
Views: 1812
|
Forum: Job Control Language(JCL) Posted: Mon Aug 28, 2006 10:27 am Subject: Im getting MAXCC=0,but not able to FTP the file |
I have removed the quotes..but still getting the same error |
Topic: Im getting MAXCC=0,but not able to FTP the file |
manesh
Replies: 4
Views: 1812
|
Forum: Job Control Language(JCL) Posted: Mon Aug 28, 2006 5:23 am Subject: Im getting MAXCC=0,but not able to FTP the file |
After submitting this JCL,im getting MAXCC=0,but ftp is not being done.
BUT in output it is saying we must first issue open command ...Need Inputs on this.......
//G54574J JOB ,,NOTIFY=&SYSUID ... |
Topic: appending the systemdate to the sequential file |
manesh
Replies: 3
Views: 1340
|
Forum: Job Control Language(JCL) Posted: Fri Aug 25, 2006 11:21 am Subject: appending the systemdate to the sequential file |
Hi,
Kolusu sorry for that posting without searching the forum......I just started cobol recently..so i dont know anything except a little knowledge on the cobol basics....and i'm in hurry for that JC ... |
Topic: appending the systemdate to the sequential file |
manesh
Replies: 3
Views: 1340
|
Forum: Job Control Language(JCL) Posted: Fri Aug 25, 2006 10:23 am Subject: appending the systemdate to the sequential file |
Hi,
I'm writing a JCL in which i'm creating a sesquential file...My sequential file name is like this 'X.Y.Z.systemdate'..............so that everytime when i submit the job,system date should be app ... |
|