Search found 7 matches

by kmoorer
Mon Aug 08, 2011 1:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date conversion
Replies: 2
Views: 1600

Date conversion

I have a date coming in format "Tuesday, June 07, 2011". How can I convert this to yyyy-mm-dd format. I looked at DateToString, but it looks like it has to be in numeric format. I can't use Iconv/Oconv becase it's a parallel job. I could disect the date, remove the day, convert June to 06....
by kmoorer
Tue May 10, 2011 9:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job continues to run but stops processing
Replies: 3
Views: 1457

Re: Job continues to run but stops processing

No changes to anything.
Just exported from 7.5.2, imported into 8.5,
compiled and started testing pointing to same database & tables.
by kmoorer
Tue Apr 26, 2011 2:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job continues to run but stops processing
Replies: 3
Views: 1457

Job continues to run but stops processing

We are converting from version 7.5.2 to 8.5. We have exported all jobs from 7.5.2, imported into 8.5 & compiled. Let's preface that this job is in production in version 7.5.2 with no problems. The job in question reads 3 sequential files each with a transform then into a join (left outer). Each ...
by kmoorer
Thu Oct 15, 2009 7:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP to mainframe
Replies: 6
Views: 2537

Well it was worth a shot. Now to convince them to use scripting. Thanks for the help.
by kmoorer
Thu Oct 15, 2009 7:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP to mainframe
Replies: 6
Views: 2537

I would love to

I would love to but I am instructed to attempt to use the FTP stage. A script would much easier, but the powers that be are worried that someone might be able to see the password.
by kmoorer
Thu Oct 15, 2009 2:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP to mainframe
Replies: 6
Views: 2537

FTP to mainframe

I am attempting to 'put' a file from UNIX to OS/390 system. The file on the mainframe is a GDG. I cannot figure out what to place in the prompts to create the file with specific record format and length Ex. - RECFM=FB BLKSIZE=0 LRECL=2500. I would also like to be able to assign space alocation as we...
by kmoorer
Thu Jan 03, 2008 2:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compiling fine in one project... not in other
Replies: 1
Views: 923

Compiling fine in one project... not in other

I have a job that compiles fine in one ETL server (Solaris on both servers). I Export the job including executable and code source, Import into new project on another server. Everything looks good. If I try to compile the job on the new server I get these errors: ##E TBLD 000000 15:09:45(000) <main_...