DSXchange

Write it to a sequential file output and then read it with the new format, but declare this file to be a named pipe so no I/O is done.

Derek - Use a REDEFINES in your COBOL FD, then force string truncation in your job by using the substring of the first n-bytes from your string length field.

How long does it take for you to dump the dataset into a flat file from the command line? (orchadmin dump)?

Ernie - I've never liked V8 too much, prefer something higher octane such as rum

If you look up the topic of capturing rejected rows on write you will see that you can store the error messages with the rows that caused them. The log files (as you've already noticed) don't always show that.

splayer - <sigh> So now your slow dataset is gone; kind of hard to analyze what could have caused performance issues now that it is gone. Did you check the orchadmin command line "ll" prior to deleting it to see if the delay was there or in DS or if any error messages were produced in the command li...

Vinod - ok, the lookup fails and doesn't find a value. What is your question?

splayer wrote:I executed the dsenv from my /home/myid directory by doing:
../dsenv

Note you need to execute ".[space]./dsenv"

What are you datatypes for key1 and key2 and what is the datatype in your DS job with which you are filling them? For those 2 values of key1 and key2 what happens when you try to manually type in the SELECT clause from the command line and the DB2 command?

suresh - if we take a step back, you are saying that when you use text values for a job parameter it works, but if you use two hash signs it does not work? Since the hash mark, '#', gets interpreted by a UNIX shell to have a wildcard meaning and is also used in DataStage in some places to mark a par...

Welcome to DSXchange, preddy! I understand the business logic from your description in the post, but the approach you are going to use to send data for new parties is still vague. Can't you select all members from the party table where there are no corresponding payments in pmt_lin to get those valu...

Derek - are the first 2 bytes of the record that denote the length actually binary or display (as shown in your original post example data)? I used DISPLAY and was having issues, but think that S9(4) binary would work.

Correct, SEQ() only returns one number. You will have to write a loop around that function.

the dsenv is just a script, copy it to your home directory and ". ./dsenv" execute it there.

Job status cannot be set per user. Changing OS-level permissions on some of the part files won't quite do it either, in addition they will generate errors and warnings for users just browsing the repository.