DSXchange

I would start with adding "-MODE NORMAL" to the command line. But how about printing out stderr in your script as well?

That's the way I looked at it, I mean adding a 0 doesn't really change a value, does it?

You need to use your favorite editor in this case. All lines count but sometimes the compiler gets a hiccup and doesn't correctly count the line numbers and will be off by a couple of lines, so use the line 777 as a rough indicator.

I added $APT_MAX_DELIMITED_READ_SIZE as a user-defined environment variable and set it, but unfortunately I got the same error.

[Addedum] - I missed a "0" in typing the size on my first test, after I fixed that mistake the job ran smoothly with large rows
Many thanks!

Do you not have the source to the routine "GetChampLigneV2" in order to look at lines 777- ?

I have a simple sequential file with just one text column and no delimiters. Each row has a different length and some of the rows are quite long (200,000 to 300,000 characters). When I try to read these rows they are rejected or cause the job to abort with the error message "Sequential_File_223,0: C...

Never , ever use kill -9. By doing so you will kill the process and not release resources. Now that you have managed to do this, you have just a couple of choices. First of all, enable your deadlock daemon; that way the longest you will need to wait in the future is the default 15 minutes between c...

The National Language Support Guide has a whole chapter titled "Creating new maps"

Could you explain your requirements again, I am not sure what you are trying to do.

If your source data has 2 columns in a file with quoted string and comma separator, i.e.

"Hello","World"

Then what do you wish your output to look like?

Hello and welcome to DSXchange, run4jeet. The question is so broad that you won't really get a good answer here. If you go to IBM Website and type in "DataStage 8" in the search window you will get 1373 documents to choose from that will hopefully go towards answering that question. Once you have sp...

Has anyone used the Solaris 10 "Zones" successfully with DataStage (either 7.5x or 8.x)? I realize it isn't officially supported but would like to know if there are any known issues with it?

I just realized I mis-typed the function, the correct one is "OCONV(In.ColumnName,"MCT")

While loading from Hash file to Sql server table it is taking 28 rows/sec That doesn't help narrow down the bottleneck. Replace the final hashed file stage with a sequential file that is located on /dev/null and re-run. Is the speed still around 28/rows per second? If yes, then you now know that th...

There is no builtin function in PX to do this. If you can write this portion of your processing in Server, then you can use the function OCONV(In.Column,"MCN") to perform this conversion for you.

When you call a job from job sequence you have to specify a value for parameter "A", if you use the value of job sequence parameter "A" then the answer to your question is "yes".