DSXchange

A "sequence" needs to be created in the database in order to use it, these are not associated with tables. You will need to issue a command such as: CREATE SEQUENCE MySequence INCREMENT BY 1 START WITH 1 NOMAXVALUE CACHE 10; and then you can use the construct "select MySequence.NextVal from dual;"

I wonder if your compile just has too many warnings. You can get rid of them by changing some, or all, of your implicit conversions to explicit conversion functions. Usually the big difference between stage variables and derivations that pops up is that stage variables are not nullable; but this pro...

Aha, thanks Ray - I thought I had edited out the "0" and put in "1" after I posted the message. As Ray correctly pointed out, the value of "0", which is the default, means unlimited rows and wouldn't have the desired results. I just re-read your post and you mentioned the input parameter, not a data...

Your example shows 3 different records, but all have the same layout; your rule seems to be to drop the last column. This is probably why nobody responded initially.

RAJEEV KATTA wrote:...If I remove the stage variable its not compiling...

If you want a qualified response, please post the error message and the stage variable/derivation to your thread.

Create a transform output link that only gets a record when you want the job to abort and limit that link to 0 records.

The DEFFUN line is used at compile time, not at runtime.
Do you use the LectureParam() function anywhere in the job?

can you, from a DOS shell window, execute "telnet {dsserver name} 9080"? If it works you will get a response and a timeout after a minute or two, if it isn't opened then you won't get a connection.

Where are you displaying this date-as-string, and are you certain this is a PX and not a Server job?

I can't recall the way the lines are formatted, but can you no use a simple DataStage job to "clean" up the data in the file?

Please use search next time as recommended, this subject is covered at least once a month. Check out this thread for example.

If you look at session management in the websphere admin window you should find this session id.

No, DataStage cannot create and write the MS-Excel file format on UNIX. There are ways to do this, but all involve purchasing extra software.

Use a transform stage with stage variables. One variable could be "svLineNo" and be derived as "IF In.Column='UNCERTIFIED - 5 YEAR' THEN 0 ELSE svLineNo+1". Then, depending on the value of svLineNo, you can output the appropriate column/line value out of the transform stage.

If the UNIX command line isn't available either, then schedule a regular DataStage job which creates output text files from the logs and FTPs or mails them out.