DSXchange

What type of stage is "Sq_AccntInfo"? What is the column "AI_City" declared as in the Database, in the DRS stage, and in the other job stages?

Pratik, a) This is a completely different question from the thread. b) This is a PX/EE question, but this thread is in a Server forum c) What exact version of DataStage on Windows do you have? There is only one version that will allow PX jobs to run, and from the error message it seem that you don't...

I don't have V8 on windows with your compiler, making it hard to find the error. I would start with a very simple job, i.e. Row Generator -> Transform -> Peek. Use only 1 column and compile. I see that you have a missing library error message in your original post - leading me to believe you haven't...

The only join possible is an equijoin; your expression column will be greyed out. The columns in the lookup file set marked as "key" must be in the input stream.

pratik,

there are so many options on how lookups are done in server jobs that no post could answer them. The best thing is to read the chapter on lookups in the server guide and if anything remains difficult to understand then you could post the questions here.

If you are reading sequential and writing to SQL-Server then you need to identify the offending line first. Could you post your source line?

Congratulations on your certification, was it a difficult examination?

No, you cannot do this. First of all, the variables won't be set while running in a DataStage job, and if you use DSExecute to set them they will not be set when the Execute returns. You can read environment variables in server jobs and sequences, but not access them directly in EE/PX jobs.

This is spelled out in the documentation; when using a lookup fileset you need to declare the key column(s) and those columns are automatically used in the lookup. They need to have the same metadata declarations and names as the columns in the stream.

So your question is how to read Excel table from Windows DataStage.

Declare the Excel sheet as an ODBC system DSN and read it from a job.

Double-posting here won't make an answer come any closer.

It seems that you don't consider READMEs to be worth reading and that the use of the builtin search engine isn't of any interest to you either. Perhaps you can rethink your urgency and why it should affect the members of this forum. In addition, the concept of an "alignment table" is not a general I...

Could you post why they aborted?

Could you post why they aborted?

PX has 2 functions that do this : CEIL and FLOOR. Try
Note this will truncate, not round. For rounding you should first do a decimal conversion using rtype "round_inf"