Search found 7 matches
- 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....
- 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.
Just exported from 7.5.2, imported into 8.5,
compiled and started testing pointing to same database & tables.
- 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 ...
- 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
- 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.
- 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...
- 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_...