DSXchange

Can anybody please tell me what is NLS?
And how to check whether it is installed or not in a system?

A pivot stage can able to solve the problem. In the derivation section of the output tab in the pivot stage, give the column names that you want to convert from horizantal to vertical form.

PadString("Pratik"," ",5) In this example, I am trying to pad the string (Pratik) with five spaces. So, the output will be Pratik . The problem with PadString() is that you can only pad a string to the right but I don't know whether it is possible to pad a string to the left of i...

I have modified the solution a little-bit: 1. Read the file with the help of a sequential file stage. 2. Next, we sort the data with help of a sort stage on the key column and set the Create Key Change Column to True. 3. Now we will be using a transformer stage to seperate the data. In the input lin...

You can provided values based on your environment in Array Size and Transaction Size in the DB2 API target stage in order to make your job faster.

I once faced such situation and by providing correct value as per my environment, my jobs ran faster.

Moreover using a copy stage between a sequential file stage and a db2 target stage helps in the job performance. As some times reading speed of sequential file stage and writing speed of db2 stage is not same and in such a scenario copy stage acts as a buffer. This helps in job performance if we are...

Moreover using a copy stage between a sequential file stage and a db2 target stage helps in the job performance. As some times reading speed of sequential file stage and writing speed of db2 stage is not same and in such a scenario copy stage acts as a buffer. This helps in job performance if we are...

I tried with ISNULL() but it is not working.

Ok Thanks..but actually in parallel job developers guide it is given NullToValue.

Hi, I am newbee in datastage. I am trying to explore Modify stage. I am going through the Parallel Job Developers Guide. There a converstion function "NullToValue" is mentioned for null handling. But when I am trying to use it in my job it is throwing error. Error Message: "main_progr...

Hi, I am a newbee in datastage. I am trying to read a simple text file through a sequential file stage. Till now everything is working fine. My question is can a .txt file hold null value? If it contains I need to handle them. I have searched other forums, there some one had mentioned that null valu...