DSXchange

We are having the same problem. No HELP? Quitting out of designer and coming back in is the only way to get a job to run. Next job to run gets indefinitely "queued".

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...

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...

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...

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...

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...

Just to be clear about my last post, the no difference in results applies to both the CFF where I got bad results (0000 for year) and the Sequential File stage where I got correct results for year (COMP) data. Tried 'em all. Does seem strange.

I've been running with Native Endian. I tried running with both Big and LIttle and see no difference in my results.

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...

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(...

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...

I found the FTP command "quote site trailingblanks" executed before the "get" command solves the trailing blank problem. I now am getting "BAD_FIELD" messages in my log for the packed decimal fields. I think I've tried about every combination of parameters and beginnnin...

I am getting records to load thanks to the help I've gotten here. The remaining problem is these "short" records. These are fixed length, 1000 byte records but some of them are coming in at 979 bytes and I am getting a "short input record" error in the log. When I look at these r...

Franklin, Your help has been very valuable. Once I got the .cfd file created as you specified, it imported easily on the first try. I've been reading logs and trying all kinds of combinations since to get the data to load. Clicking the "Print Fields" check box on the CFF "Record Optio...

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...