DSXchange

The data cannot be read correctly as columns in DataStage as it isn't well-formed. If you specify the string columns are not having quotes your one column will be read as "T120 20" TFT Monitors" You can then strip the leading double-quote and trailing double-quote from the string. If ...

I'm at a busy phase at work so can't just test this - perhaps someone else here can; I have to admit I'd be very surprised if this isn't supported. Do you have access to support?

Well it is a premium post... but it cruelly cut off the code just mere characters away from the important part:

Offhand I'd program this as a UNIX/DOS exit from the job sequence, using "wc -l" on the file to get the number of lines, or if the file really needs to be checked then a "sed" or "awk" command to parse out the date.

The code line " Var1= Field(Arg1,'%',1) " will return the full string to the left of the first "%", i.e. "$50 copayment, 30". TempString=' ':Field(Arg1,'%',1) Var1 = FIELD(TempString,' ',DCOUNT(TempString,' ')) That will add a space at the beginning of the string, then ...

That all looks correct. Can you reduce the COBOL Copybook to just one record format and just that one column and run it with your 4 record sample to see if the problem remains reproduceable?

I have written some build-ops but I can't post customer code. What I can do is remove most of the operative code to give you an idea of what happens. In the code posted, the build-op does it's own record processing, i.e. it takes over from DataStage and does all reads and writes by itself; normally ...

Peep - as has already been mentioned, there is no single log, you need to look at the log of the job in question, starting with the director log. "page spacing issue" is rather vague - did you actually run out of page/swap space? Or temporary disk space? Or disk space? Is the paging area(s...

In the CFF stage "Layout" tab, what is show for the column DTLRCD.AMT in both the DataStage PX format and the COBOL view?

Craig that's what I actually wanted to say I don't know how I managed to write that.

When you say user-id and admin-id you mean as the argument to the DB2 database stage or as the DataStage designer user?

Is the file coming in as EBCDIC? If so, at least the conversion is working correctly. Also, do you have any rows where the rightmost position is a number (which would denote a positive value for me)?

remember that the search rules for $PATH and other environment variables is different when called from a DataStage background process than when called from your user. 1. Explicitly use the full path to your sendmail executable. 2. If (1) doesn't work, add some debugging and echo commands to the scri...

It would be nice to know what the values and the corresonding strings in the file are. If the last digit is correct with positive numbers and only a string when the values are negative then at least we know for certain what the representation is. The CFF stage should still be able to interpret this ...

By doing an integer division of the days by 30 you will get months. It really depends upon the application whether this is "good enough", otherwise one would need to extract the year(s) and month(s) from both variables and perform computations on those values, i.e. "((year2*12)+month2...