DSXchange

is there a separate manual for the Modify stage? 'cause I couldn't find much in the Datastage Help (in the Designer) nor in the pdfs...

This only goes to show that DataStage has to seriously update its documentation! :D

Is there any function in PX to find the ASCII value of a character? I know that the Char and Seq functions in Server are used for this purpose but there do not seem to be any helpful suggestions in DataStage help...

Thanks in advance!

Hi,
I have searched the forums and found out that the upper limit for BigInt is 2,147,483,647.

Can someone please let me know what is the upper limit for Integer?

Thanks!

i am not really sure what more i can tell, the same job fails if the disk space or the scratch space becomes full... which is appropriate... but the job does not fail when the buffer file is full.

i hope someone can explain APT_Bufferfile is and how it functions, etc..

thanks very much!

buffer(3),0: APT_BufferFile: unable to create file 000000000000001c: No such file or directory APT_BufferFile: unable to create file 000000000000001d: No such file or directory however, the job doesn't abort. Hi, I have encountered the same kind of issue. I have received a fatal error as specified ...

Hi, I have encountered the same kind of issue. I have received a fatal error as specified above. But the job doesn't abort. However, whenever the disk space was full or if the scratch disk was full, the job aborted "successfully" ;-) Shouldn't the job abort when the buffer is full? Why doe...

Yes I am writing to a sequential output file. Actually, there is no performance bottleneck, per se... but we are just looking at possible areas which can be improved. Like I said, using Double increases the amount of disk space that we might need. In that case, using Decimal is better as it uses qui...

You are right Priya. I think was acting on assumption that it was 4 bytes. But I tried running a job which gives a 30 GB output with Double, and the same job gives a 17 GB output file with Decimal type. All the data is intact with the Decimal type except that the format is different. But can someone...

Hi, I have a set of 20 to 25 long running PX jobs (each job runs from 3 hours to more than 5 hours). I have been asked to look at ways to improve the performance. I observed that the Double datatype had been used as a default for most dollar fields in the jobs inorder to avoid arithmetic complicatio...

Hi,
Where can one get the Orchestrate Operators guide? I have searched Google high and low but I am still not able to find out...

Can anybody help me? thanks!

Thanks Ray,

..also the benchmark reports are usually skewed, for instance NSort once showed that they were faster than SyncSort on one system, while SyncSort showed that they were faster than NSort on another system!

Coming to my query.. does anyone have any published reports? Thanks!

"it was felt"?!! Shades of the old "statistics have shown"! By whom was it felt? Based upon what? Have you designed/conducted any tests of your own? I have no information, but would be surpri ... I have already mentioned that I do not have the facility to conduct tests on large ...