DSXchange

but how do i use it? i tried with the link given by ketfos .........i t was really good.
but i wasn't able to edit VOC file
how do do that and create columns in hash file through admin

I tried creating a hash file through admin with command CREATE.FILE. This allowed me to create files asking the type,modulo and separation etc. My questions are But how do i specify the columns definitions and others....... How do i edit the voc file and make a diffrent dictionary point to a data se...

Is there any possibility of using a hash file as table. I have a set of entries in hash file and i would like to select data based on conditions 'between', 'where','having' etc.... But these can be done only in a table. Is there any way convert a hash file to a table and query the hash file. I have ...

I had a job which generates some sequntial files processing the input data files. I saved it under an existing project. The job got compiled and i was able to run it sucesfuly for the first time. But there was a error thrown in the log and said it was not able to load the log detials (mid way) When ...

I am not able to load records into the UV table. The cause for rejections is stated as Mismatch in Data type in Log. Intial design was directly loading the UV table from transformer. Only certain records get rejected But when tried using an intermedaite sequential file between the transformer and UV...

Do the UV tables that DataStage Operates on, has any limit for space it can actually hold We have some 3 lac records (of size 1.2 GB) that are added to the table and the table is looked up for. In the process of writing from the transformer stage to the UV table it throws an error stating "An i...

thanks for the info, but is there any limit for sorter stage... it is quite logical the sorted data can be better handled by agregator to add upon, can i use a hash file stage if my application is to sort the data and juz eliminate the duplicates and use the first incoming one. which algorithm in th...

Is there any limit for aggregator stage in handling rows Every time i run the job it fails with a msg 'aggregator terminating abnormally' so is it because of the huge input volume. i am not able to process huge input of volume of 3 lakh records. i basically split the input volume to handle this situ...

Hi, I tried executing dsjob -jobinfo <project> <job> Job Status : RUN OK (1) Job Controller : Batch::ATMFiscalPeriodLoad Job Start Time : Mon May 9 08:25:17 2005 Job Wave Number : 2 User Status : not available Job Control : 0 Interim Status : NOT RUNNING (99) Invocation ID : not available Last Run T...

Hi Srini,
thank you. it worked

Hi All,

How do i find the columns in DS_JOBS and RT_LOGnnn tables?
or
can someone tell me what are the columns present in these table?

thank you. it was working for me

Hi,

dsjob -logsum -type BATCH -max n <project> <JOB>
What does the option BATCH refer to? What details does it fetch?

Hi,

Can some one tell me what for the message tracking options like
Priority
Sequence
Correlation Id
Put Date
Put Time
Group Id
Offset
in the output tab of MQ-Series Stage used for?

Hi Kim,

Thank You. But unable to find the BASIC or Shell Script code. I am not exposed much in coding shell script for DataStage.