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 12 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Adding 2 columns to a DB2 table
manesh

Replies: 2
Views: 3671

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

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

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

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

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

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

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

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

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

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

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

PostForum: 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 ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group