Search found 19 matches
- Tue Aug 19, 2014 9:08 am
- Forum: General
- Topic: Jobs remaining at status 'Queued'
- Replies: 6
- Views: 5440
- Tue Aug 12, 2014 7:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Enterprise Disable Constraints Option
- Replies: 1
- Views: 2509
Oracle Enterprise Disable Constraints Option
The Oracle Enterprise Stage Properties panel offers a "Disable Constraints" option. It also offers the Index Mode options of Rebuild and Maintain. I am loading to an Oracle table with a Primary Key Constraint and of course a Unique index. When I set Disable Constraints = True, the log stat...
- Tue Apr 29, 2014 8:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execute PKZIP on mainframe
- Replies: 9
- Views: 6747
Just found what I think will be the answer to my requirement. The implementation of FTP on z/OS systems includes the command FILE=JES. This enables a JCL coded file to be transferred to the mainframe via FTP and sent directly to the JES (Job Entry Subsystem) for execution. It also allows output to b...
- Mon Apr 28, 2014 10:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execute PKZIP on mainframe
- Replies: 9
- Views: 6747
They have been using PKZIP for years, apparently with no corruption issues. We don't have shared drive access to the mainframe, and ftping the uncompressed test file takes 98 minutes, not acceptable in the timeframe we have to do several of these. I know nothing about the compression protocols or DA...
- Mon Apr 28, 2014 9:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execute PKZIP on mainframe
- Replies: 9
- Views: 6747
The reasons for the restrictions are that at some point DataStage was sold to the funders as a complete Do-All replacement of the pieced together set of processes currently running but turning into a maintenance nightmare. My suggestion that ZIPping code could be tailed onto the existing (and to con...
- Mon Apr 28, 2014 8:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execute PKZIP on mainframe
- Replies: 9
- Views: 6747
Execute PKZIP on mainframe
What possible approaches are there to create a job or UNIX script that can ZIP an existing flat file on a mainframe Z/OS system (all display format, no packed or binary data) in preparation for ftp'ing to our DataStage server? PKZIP is installed on the mainframe. We are being required to do this str...
- Tue Mar 11, 2014 2:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL flat file import
- Replies: 28
- Views: 20565
- Tue Mar 11, 2014 10:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL flat file import
- Replies: 28
- Views: 20565
- Tue Mar 11, 2014 9:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL flat file import
- Replies: 28
- Views: 20565
I just had success on all fields with the Sequential File stage without a transformer. The combination of setting the Output Format parameters along with editting the individual Column Meta Data for the packed decimal and binary fields works like a charm. Clearly this wouldn't work with OCCURS field...
- Mon Mar 10, 2014 3:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL flat file import
- Replies: 28
- Views: 20565
Franklin, I think I've picked up that you wrote the FAQ that I've seen referenced many times in regard to working with Mainframe files. I still am not able to get access to that topic. Is it possible you could get that info to me via email or another link? I tried the suggestion of DecimalToDecimal(...
- Fri Mar 07, 2014 4:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL flat file import
- Replies: 28
- Views: 20565
An update here.... I have now been able to bring in all the data types except the two PIC S9(4) COMP fields. I discovered an article in IBM documentation about the iSeries servers (which is not the server I'm transferring from) that suggested using type EBCDIC and mode BLOCK to ftp the data. That ge...
- Wed Mar 05, 2014 1:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL flat file import
- Replies: 28
- Views: 20565
- Mon Mar 03, 2014 10:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL flat file import
- Replies: 28
- Views: 20565
- Thu Feb 27, 2014 11:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL flat file import
- Replies: 28
- Views: 20565
- Tue Feb 25, 2014 3:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL flat file import
- Replies: 28
- Views: 20565
FranklinE, Thanks VERY much for your responses. It looks like I may be creating the copybook file myself. Am I correct in my understanding that what is required here is just a text file with the data definitions as you've described in it? I have such a file without the preceding 05's or the 01 recor...