DSXchange

If you look at your sequential source file and it shows "06/04/2006" displayed in the first 10 positions (as the error message shows) then it is a character field which happens to contain a date in the format of dd/mm/yyyy {or perhaps mm/dd/yyyy ). You can read these 10 characters as a string and th...

Does the job show "running" in the Director? Are the Windows processes for this job still running or have they completed and finished? Are you certain your 2-node APT_CONFIG file is correctly formatted? Will it work with a 2 node configuration if you write to a dataset instead of a database? What is...

Koti, Ray's post stated the same thing that I did. If the file does not exist, the ELSE clause is taken; even though the file pointer is created and you can write to the file. Normally an OPENSEQ should be called with following syntax if you wish to write to a file and also to create the file if it ...

Koti, in my previous post I suggested you use an ON ERROR clause and output the value of STATUS() in order to find out what your error is. I doubt that Ray posted a message stating that the OPENSEQ will take the else clause if a file exists. This is not how the OPENSEQ command is documented and not ...

In your DataStage home directory there is a text file called uvconfig which contains the values for these and other configuration parameters. You can edit this text file with vi . Once you have made the changes you need to execute bin/uvregen and then all you need to do is to stop and restart DataSt...

An OPENSEQ will take the ELSE clause if the file doesn't exist (this is normal behaviour and the file is opened) or if there is no ON ERROR clause and an error occurs. You should add error handling and also display the value of STATUS() to find out what is going wrong. Perhaps you don't have r ead p...

To put your question differently, you have just asked "I am driving from New York to Los Angeles. How long will it take me to get there?". Well, are you using a truck or a Porsche or walking? Are you going cross-country or using roads? The list of questions goes on and on. The same applies to your a...

The categories were added several releases into DataStage and, as far as I know, there is no API call to get this information. This is one of the few cases where I do advocate going underneath the covers and using code. GetJobCategory(JobName) OPEN '','DS_JOBS' TO JobFilePtr ELSE CALL DSLogF...

What is the definition in the DB/2 Table for this column? If it is also char(10) then try using "0000000001" with quotes.

This is an emerging technology about which not too much has been written. IBM and Ascential are good sources, and I saw this page which also has several references at the end.

The field is a char field, so you need to declare it as such. Then, as part of your job in a modify or a tranform stage you need to convert this dd/mm/yyy formatted string into a date or a timestamp type field. Since you haven't specified which you will need to look at the developer's guide and choo...

If you cannot put this condition into your source SQL reading from the table, you can add a constraint in a transform stage with a condition like In.MyColumnName => 201

There is no recovery from a deleted job - the delete removes the job and all the contents immediately.

Both Ray and I suggested you read the HELP regarding how to set the incomplete columns. From the question in your post it would seem you decided not to follow that advice! Only columns starting at the end of the line and going backwards can be set to incomplete.

Parag,

go into your designer sequential file stage in the columns tab, and scroll to the right to see the incomplete column column. Also, try using the HELP and search for incomplete.