DSXchange

How about the reject link going to a basic transform stage which simply calls Takes care of the logging and the abort.

Can you not run the reject through a transform stage and constrain the output of that transform to your sequential file at one row (plus you need to clear the cleanup flag in the sequential stage so that the file is not rolled back upon the abort).

The command to execute from TCL is "ACCOUNT.FILE.STATS", and the shared memory analysis program is called from the unix shell in the {./dshome}/bin directory as "analyze.shm".

Code would be:

MyString[1,Index(MyString,':',ColumnNumber)-1]

or

Field(MyString,':',1,ColumnNumber)

Tony - no, you did explain it well; Devyani just missed it

I would use three stage variables in the order as given

(a) CurrentValue = {current column or columns concatenated}
(b) SameAsLast = IF (LastValue = CurrentValue) THEN 1 ELSE 0
(c) LastValue = CurrentValue

And in your constraint put NOT(SameAsLast)

Devyani,

the DEFFUN statement just declares the function, you actually need to call it using

Sanjay, remember that the issue is only urgent for you, not to any others on this forum - for urgent solutions you will need to go to your support provider. Be that as it may, Sainath has already showed you where to find your solution. In the sequential file stage of Px you have a number of choices ...

Sanjay,

man, I'd love to help, but....

Stefl, first off - the question isn't really an odd one; it is a subject that most of us have come up against in the past and/or will most likely encounter in the future. The most important part of ensuring a smooth transition of jobs between the environments is parameterization - without that you a...

Use a UNIX level sort (or if you really want to, use a sort stage) to sort your input data - optionally the sort program can and will remove duplicate records for you. If your data is sorted, then you can use a stage variable in a transform stage to compare the current record with the previously rea...

Since the format is yyyy/mm/dd you can do a simple string comparison, so your result of doing a ( '2000/01/01' > '1999/01/01' ) will return true. What is the condition you are testing - so that we might see why you state that it is wrong...

I just tested to see if the EBCDIC(ASCII(high-value) works and it does, so I am not sure why you are getting this error. I'll have to see if I can just create a test file with high-values and a PIC X(7) column. Does each position have a high-value in your string, or just the first?

snassimr,

please explain how you are comparing them? If you do a "1999/02/02" = "2000/01/02" you are going to a get a 0 {wrong}. What are you trying to compare - their equality? Days between?

Udayashankar,

what happens if you open a cmd window and execute the "d:\Ascential\DataStage\Engine\bin\dssmtpmail.exe -file sendmail_55685_593_file.tmp" command line?