DSXchange

Do a job reset and look into the new message(s) in the log file, often they contain additional information.

irajasekharhexa , DataStage jobs can be declared as "multi instance" and can run any number of times in parallel. Since these jobs are completely separate from each other you need to make sure that they don't attempt to write to the same sequential files or have similar concurrency-related issues. Y...

No, this type of COMMON is only found in the BASIC engine. You will need to use other constructs from C

Common blocks or groups of common variables are shared across programs within the same process. If you declare the same COMMON/mycommon/a,b,c in several subroutines they all use the same memory locations and values for a, b and c. Common is also persistant across calls, so if you repeatedly execute ...

Kumar,

the key in a hash file is always unique, so doing a subsequent WRITE to the same key will overwrite the previous value; thereby removing duplicates.

-Arnd.

Hello gurvi and welcome to the DSXchange forums. The "search" facility will give you lots of posts when you query on either "CRC32". "incremental loading" is a bit different, as the subject is a very broad one and rather basic to data warehousing as well. If you have a specific question that hasn't ...

Sometime when jobs abort they do so in such a way that they write to the standard output, which is captured in the logfile and is then displayed upon doing a reset. Sometimes, though, the job aborts without writing anything to the output stream and in those cases a reset will give you no additional ...

Ashwin, a signed COMP-3 field with a 0 value will, in binary, have all 0's except for the rightmost 4 bits, which will have some value to represent the sign. I don't have cobol access here, so you will have to figure that value out yourself. Once you know it, you can built a string that contains the...

The disks are in a SAN - we have 8 nodes on 8 different scratch devices to spread the load. I did a quick search in AIX and couldn't find a device busy - the only UNX reference was with NFS mounts, and perhaps a SAN could be considered as network mounted drives. According to the OS guys the SAN prot...

Ashwin,

I would declare it as a simple array of 1200 times PIC S9(11) COMP-3. Since you fill the values to 0 the position doesn't matter.
15 MYARRAYOVERLAY REDEFINES DataGroup.
15 MYARRAY PIC s((11) COM-3 OCCURS 1200 TIMES.

The FILELOCK goes the the file variable, not to the name. So in your case it needs to read "FILELOCK SeqFile2".

Pongal, In my previous post I said you will need to do several things. I will go through and elaborate how I would do this. 1. Declare the input sequential file as having no delimiters and read in one column, calling it Big. 2. Convert the first " and the last " and all occurences of "," (the double...

Exactly

Yes, so the next question's answer is: If you read in the whole record as one string and parse it using a search pattern for "," to get valid string quotes plus the first character of the line and the last for the opening and closing ones. Any other quotes you can replace using the aforementioned me...

Craig, I'm just starting to pluck apart the PX export file. It's pretty long and complex, but I think that Im on the right track now. With all those columns I have distilled it down to only 8 conversion rules - much less than what I had feared! Thanks again for all the suggestions and help. It reall...