DSXchange

Ray - I have that same problem sometimes as well. Often I find I am trying to start the wrong motorcycle. So the answer to your question is "do not smoke while mixing explosives in your kitchen"

naren6876, add a parenthesis, the line is

I wonder if you are hitting a configured UNIX limit on file descriptors - what platform are you running on? If you run it with less nodes on a single server, does the error persist?

With Oracle loads the APT_ORACLE_LOAD_DELIMITED setting affects how spaces are automatically trimmed, but that doesn't happen in DB2

Server jobs will put quotes around columns that are declared as string. You can load string data in server into a column declared as numeric and DataStage will not complain. Those columns will not have quotes around them when written to a sequential file. The first thing you need to do is look at yo...

Unlike Sanjay, I can depend on datasets and lookup filesets and believe that the overhead involved in #1 is very high compared to option #2. I have done some performance tests with regards to lookup filesets in the past and repeated a test yesterday where a data stream of approximately 2.5million ro...

I think that while the single files created in a lookup fileset might be limited to 2Gb each the engine will create multiple files per node, not just one as you impy.

Your reject mode in the sequential file stage should be set to "output"

While i execute this job the project got corrupted. Does this mean you can no longer login to the project in DataStage? If you login to UNIX and attach to the path of the project, do you have hundreds of files in that directory including one called "VOC"? If not, you had best hope that your last ba...

Hello and welcome to DSXchange!

Is "next time" the next call in the same session {in which case you might be able to use COMMON in the routine} or the next run {in which case you would need to store the value to disk, perhaps using one of the KeyMgt... routines in DataStage}

DSRajesh - everyone else in this thread has already suggested or recommended doing this somewhere else by more efficient means. If you really must change the routine we could give you a couple of lines of BASIC code to do this, but that would be a premium post that you would not be able to read, so ...

nynali - what platform are you on and which compiler are you using? Once you get that information find the relevant manual or web page and see if the compiler will allow that 32Kb value to be raised. I doubt it can be. You've seen that by shortening elements of the job such as name, stagenames, link...

What happens when you manually enter the SQL with the appropriate key inside your favorite SQL query tool - do you get no matches or 82?

You can lookup on the database and hashing doesn't apply in this context in server jobs (is this a server job?)

You would execute the command
to put the first line of AUSTRGnnnn.txt into AUSnnnn.txt

cosec - how did you verify this? Since DataStage found 82 matches on the key you supplied, yet you are certain there are not matches you have eitehr got a problem with your logic or have discovered a bug in DataStage.