DSXchange

Nelc

Ray kindly posted a user-defined function that calculates the number of completed months between 2 dates in http://www.tools4datastage.com/forum/to ... C_ID=84773

Stephan

Srinivas may the experts correct me, but to me it sounds like a case for a hashed file: - manipulate your string so that each name/value pair appears on a separate line and write the result to a sequential file. In a separate job, read the sequential file and write it to a hashed file with the name ...

malathi,

we have the same problems sometimes and in our case it seems to be related to the 'preload file to memory' option' in hashed file stages, especially for 'larger' lookups (500.000 records and more). After disabling this option the 'Abnormal Termination' doesn't occur again.

Stephan

Ken

I must admit that my English reaches its limits here. I was able to fancy what AFAIK or IMHO is , but BLAMMO [?][?][?]

Stephan

Kim, Ray

thank you very much, indeed, for your explanations. I really appreciate them.

Kind Regards

Stephan

Ken you assume that the Job / the Server is running out of space 'somewhere'. Are you serious? When you start to learn a programming language, you're usually taught to ensure that you have the resource you want to use, otherwise issue a warning and terminate, if necessary. If a DataStage server can'...

Aphrodite, one possibility is to write the value to a hash file (possibly within a sperate job). The hash then can be read using UtilityHashLookup. Within your controlling job (if you have one) you can read that value and pass it as a parameter to the job that queries the oracle table. I guess, anot...

Raju I wonder what your query looks like, do you have a subselect to get the max(id) like select contract_no, id from table a where id= (select max(id) from table b where a.contract_id=b.contract_id) which i would expect to be slow, or do you select contract_no, max(id) from table group by contract_...

Hi Laura, I never used sequencers and never heard of the mentioned ?Jobinfo? types. But to me it sounds like you could do what you want if your condition would be: DSJ.LOGWARNING>0 And DSJ.LOGWARNING=DSJ.LOGREJECT which means: there have been warnings and all warnings were rejects Hope this helps! S...

Can somebody please enlighten me on common variables, especially their visibilty and lifecycle. What I understand, is that they are something like global variables. Where can they be used, in batch jobs and/or routines? Where are they visible? presumably only in those batch jobs / routines that dire...

Ken

thank you very much for that interesting information. I only wonder, why manuals and online help are so perfectly unclear on things like that.

Stephan

Kim

handling it as varchar is probably not enough, you will have to ensure that the data has the same format on both sides, e.g. number of decimal places, leading zeros, etc.

Stephan

Kim I tried something similar formatting the numbers to have two decimal places, which dramatically increased the hit ratio. Till now, I only had integers within key columns, so I never became aware that the comparison doesn't seem to be numerical, but character by character, thus '.5' not matching ...

I'm a bit reluctant to use uv-stages. On our system (HP-UX 11), they tend to cause even more problems than hashfile stages, especially regarding 'Abnormal termination'.

Stephan

How is a lookup performed on fields that are declared to be numeric both in stream and reference input? I would have expected that it would be done numerically, but it seems that a record can't be matched, if the lookup has 1.0 instead of 1.00?

Stephan