DSXchange

I think the answer here is "no". You could create a job parameter to hold this value and fill it at runtime with the current time from a calling Sequence. If you don't wish to use a sequence, you might be able to define the FTP stage in a shared container and pass the datetime in as a parameter - us...

You need to add a statement and then just use the IN_RTN_1('a') call.

Try using the DataSet tool or the UNIX orchadmin ll command to find out what the real schema of the dataset is. I would think it does have that column.

Stefan - I think the ConnectDirect or mainframe issue is that some files can have compressed spaces which are not interpreted/expanded correctly when doing such transfers. The compressed spaces binary values can sometimes show up in COMP-n fields and thus cause the file to be expanded incorrectly.

The documentation for the FTP stage is sufficient to use the stage, but it doesn't explain the complexities of using FTP on mainframe; the assumption is that you will get that information elsewhere. Can you connect and transfer data using the command-line FTP program? If yes, then you can use FTP St...

If you do a binary transfer, i.e. with COMP-3 fields in the file, you won't need to do a conversion on the mainframe; but it does make life easier when you have EBCDIC (or ASCII) text only files.

Yes, you can use the FTP stage to do this; but you need to make sure that the systems have been configured to talk to each other.

I'm not sure if DataStage will run on 64Bit Linux; you will have to check the product/platform list published by IBM. But there is no problem using 64BIT hashed files on systems running only a 32 bit operating system; DataStage takes care of the internal pointers, not the OS.

Set a constraint of "1=2" on the output of your transform stage. Does it still process only 20 rows/sec at high CPU utilization? If yes, then you have an issue. Using high %age CPU amounts in DataStage is usually a good thing.

The kill -9 is not interruptable, so the process died and was unable to release it's locks. This is why we always recommend not doing a kill -9 . In your case I would recommend (a) Enabling the deadlock daemon. This will, in the future, automatically cleanup after issues like this. (b) Login to eith...

I can't seem to get this to work, and since I don't have a UNIX login I cannot experiment. Basically, I would like to add a CR and LF to the end of a file being read in a PX sequential file stage. The Filter is already being used to uncompress the file and reads "gunzip -c" but I would like to add a...

Does the job run? What stages does it use? If you remove stages one by one, after which stage was removed does it validate?

Interesting, when I did a search just now I found This thread

Is the column type a string? If so, just use

Hello and welcome to DSXChange!

Your error message indicates that you have left the length of a string data column set to 0, which DataStage does not allow.

Moderator, please remove this thread, it is a duplicate of this one