DSXchange

Hi All, Can some one let me know if we have the below options in datastage, 1. Need to figure out, the time at which users loggin and logout of datastage. 2. When datastage abruptly terminates connection, does it maintain the reason for termination for each user with the timestamp ? Thank You for t...

No. There is a stage type called Generic. RTFM?

You test ErrorCode = 0 early in your routine and bypass the remainder of the code if this is not true. However, ErrorCode is in an unassigned state at this point (so can not be equal to any value). Remove this test. ErrorCode is an OUTPUT argument.

Most of the SDK functions are cataloged with an all upper-case name. This is the name you use in the CALLING clause of a DEFFUN declaration.

This is a different requirement from your original one, and probably deserves a separate thread. We answered the question you asked.

If you know the maximum possible number of fields, parse into this many columns, and set the remainder to NULL. Then run through a Pivot stage.

Welcome aboard. :D What you describe is a very unusual scenario - a binary file with other than fixed length records. Do you have any description (such as a COBOL file definition) of the structure? It may be that there is more than one record type - you need to know this before you can proceed. Once...

Not unless you can tell us what you (they) did to the VOC file. Can you execute SELECT "NAME", "DESC" FROM VOC WHERE TYPE = 'F' FIRST 4; from the TCL command prompt or Administrator client command window? If not, try INSERT INTO DICT VOC (F0,F1,F2,F5,F6) VALUES ('NAME...

Here are the senario. -I load the data from 30 days back till current date. -After I loaded the data,the user may delete some records for past dates.So there are more records in dw than source db. -It happens like regularly. -So I would like to replace all the past data whenever I load it again.But...

Possibilities include that you don't have write permission to /tmp or that the file system on which /tmp is mounted became full at some point.

Some of us don't come out on film, don't have reflections in mirrors...

Do you have a separate output link for each record type?

Consecutive stages of the same type are not supported for some stage types, such as Modify stage. Put a Copy stage between them.

It means that you need to generate output with tags.
For example, the derivation of LastName might be

That is not possible from the code you posted. Are you certain that there is no wildcard character in the pathname you generate for the ERASE command?

This horizontal pivot looks very like a job for a Pivot stage to me.