DSXchange

:? Has a beginner I want to understand why there are two data types defined on a column : SQL data type and data element. The product documentation nor help is not any good in describing the sql data type any better than repeating its name. Help says that data element usage is optional but enables s...

Hi Ray, Ascential support people help me find out that I had not enough RAM available of my machine (wich was also acting as the server) and that virtual memory management was actually causing the problem. Setting the VM to a fixed size of 3 time my actual ram (128 thus 384 meg) fixed the problem. I...

I am a new user doing the tutorial with DS 7.5. I get the same error message in a w2k environemtn for many server jobs. they run well w/out trace in both director & designer. when tracing it sometimes abort w/ this msg! I also used to log with the omit but now enter my uid/pwd but get the same b...

Hi,
I'm new in Basic language. I would like to know how to implement the sequential reading of an hash file records. Every example I saw on hash file reading showed me the reading of records using the key.
I'll appreciate any kind of suggestion.
Thanks.

Stef.

Hi all, I have to load a sequential file (the fields are comma separated) into an Oracle table. One of the fields is decimal 6 with scale 2. Values for this field are for example: 100.40 399.00. Nothing is copied from the file to the Oracle table. The error message is "not valid number". A...

Ray, I executed the command: LIST SDKSequences F1 and the result was: LIST SDKSequences F1 11:05:50 07-30-03 Page 1 SDKSequences F1................ 0 1559 1 1551 28 3 records listed. I executed many times my job to observe their behavior. What I simply want is to have a table A having a surrogate ke...

I forgot to say that I generated the surrogate keys using KeyMgtGetNextValue(varXXX) in the first job and KeyMgtGetNextValue(varYYY)in the second one.
Bye.

Ray, thank you for the advice. I simply have to generate independent table in different job. I generate the first one days ago, and the second one now. The surrogate key are completely independent, and I want them to start from 1. But even if I used different stage variables in the different job, it...

Hi all, I'm a new DataStage's user. I designed two jobs: - the first to generate a surrogate key for table A; the value are 1....1000; - the second to generate a surrogate key for a table B; I want this surrogate key to start from 1, but it start from 1001. I have used different stage variables to r...