DSXchange

Nelab What is z03 (node1 ) ?? Do you have a folder by that name or is it a typo. Have you resolved your problem?? node "node1" { fastname "DBPU2" pools "" resource disk "/z03/tempdataset/" {pools ""} resource scratchdisk "/z03/tempdataset/scratc...

Babu
It looks like your Ar03.sh has some problems. Check the line numbers indicated in the square brackets.

And if you think it is a dsjob usage error please post your full command,

T42
Thanks for your suggestion. I tried what you suggested in DS 7.5. It did not work for me.
I prefixed my hex data with 0x.

The data was something like 0x00CF. It had a type varchar.

I tried Integer as output. Also I tried AsInteger function. Both did not work.

Hi
I tried that. I am getting the following error message

Link DSLink18, Column DEVICE_CODE: ICONV(DSLink15.DEVICE_CODE,'MX")
Variable 'ICONV' not defined

I am using this in the transformer stage.

Thanks

Hello I have a varchar which has three hexnumbers as input to transformer. I extract each hex number and use them as 3 output fields. Input : 0000FE00230064 0000FE 0023 0064 fld 1 fld 2 fld 3 Result I need 254 35 100 How can I convert the individual fields to integer values in the transformer?? Than...

Hi
You are saying this is a parallel job. You may want to take a look at the db2nodes.cfg. Can you tell about the partitioning info of the remote table??
Thanks

Hi
Modify can be especially very useful in null handling.
Most other functionalities can be easily done using transformer.
If you use a copy stage to make copies, it makes more meaning to the others who see your jobs.

PS:
Modify and copy operators were indispensible in Orchetsrate scripts.

Thanks

Anupam
What are you doing in your 3rd job?? Are you doing some cleanup and trying to reset some jobs??
Thanks

netboyks First make sure your new config.apt is using the same nodes as the old config.apt. Using the new libraries try the following three commands. dsrecords olddataset.ds orchadmin describe -s olddataset.ds orchadmin dump -p 1000 -name olddatset.ds If these three work fine, most likely you can do...

vmcburney As you were mentioning "I will play around with sorts and transformers and maybe custom stages to find some way around this." Just for count distinct you can use sort with stable unique option. Of course in the main aggregator stage you want all your records. So just for doing a ...

Hi I am not sure if you will like it. But this is what we are doing. And it works great. Yes we do process huge volumes of data. We are using transformer's substring operations. Yes. Basically rip the 25 char string and build a sring of different format. By any chance can you get your input in your ...

Stone
Did you check the logs for the individual jobs . The fatal error may be in there. Sort the jobs by start time and look for the first aborted job.
Thanks

Ray Thanks for your comments. LIST.LOCKS is one of the commands we have been regularly using. Whenever we want to bring down datastage services we do the following Ask everyone to close ds double check using ps -ef and bin/uv LIST.READU To check if there are user locks bin/uv/ LIST.LOCKS. If there a...

Hi
If you have Data Quality Check scripts you can add two lines to check it.

USe dsrecords <datastaname> to get the count of records in the dtaaste

selct count(*) from table where timstamp > previous run

Thanks
dsxuserrio

Hi I have used only the following commands in the command window. Instead of LOGTO you can click on the project to choose it. LIST.READU LIST.LOCKS LIST>FILE.STATS and see logs using SELECT * FROM RT_LOGxx; You can instead use $DSHOME/bin/uv and use all the above commands plus the folloowing LIST.DI...