DSXchange

That output looks correct, you have found that the JOBNO for that job is number "6". What do you think your problem is?

If you can go into the TCL environment, then issue the command "VLIST DSD_BP DSD_RUN.B" and post the lines with 2160 through 2170 in the left hand column.

From unix, attach to the project directory and issue a "du * -s | sort -nr | head -10"
Is one of those files a log file and how big is it?

$APT_DISABLE_COMBINATION set to "true"

Lol - I missed that.

mydearsyed wrote:...I have been told that the maximum capacity of Datastage on a 32 bit OS is 4 GB of RAM...

This is not a DataStage limitation. Windows 2003 has physical memory limitations, but the virtual memory that DataStage sees is significantly larger.

Hint: You only have a Julian date if

is equal to 12350

Does a disk object exist at "/dswrk/dev/data/H_DWH_SURR_KEYS"? How many objects are returned if you enter "ls -al /dswrk/dev/data | wc -l"?

Perhaps the disk files are not there, but the VOC descriptor is.
Please post the full message and also what method you are using to create the file.

Turn off operator combination and see where exactly your error is occurring - in the stage var or the derivation.

the internal malloc() and free() statements are not documented. No, this is not applicable to only server jobs. No, there is no internal program for memory management. Server strings are not contiguous, so Server tends to allocate smaller chunks of memory at a time and only when necessary - this all...

The DataStage Parallel Job Developer Guide on pages 30-33 show the different date formats you can display. The day and month in text will work, but the year will have to manually constructed in text form.

iDomz - that approach can work and is a good thought, but since PX jobs run in many processes and the ulimit setting is per process you will only achieve a very indirect control.

What if you were to assign a stage variable to the function result, then use the stage variable in the StringToDecimal function - does that work as expected?

Congratulations on the achievement! When I grow up, I'll take the test and hope to get as good a score!