DSXchange

Hongqing Tang wrote:That issue started last week. Today, I went back and tried it again, I am having the same issue.

Are you sure you are the only user of this shared container?

ArndW wrote:datisaq - I use the windows taskmgr to see the client PC usage and have sometimes seen the local CPU and particularly the I/O go up significantly during compiles, this is because parts of the compilat ...

What does "datisaq" means here

depends on which version of data stage you are.

if you are on 8.1 , you can use in built SCD stage.

In some companies, they do run patches, mostly weekly, to remove the softwares from the machines which are not under the list of the aunthorized softwares for them yet. We also had same kind of problem where in data stage version 7.5 was under company's approved list but version 8 wasn't. You need t...

ray.wurlod wrote:Tools > Data Set Management in Designer.

You can also set the Peek stage to capture only from particular nodes. (I can't recall whether the same capability is available from the data browser, t ...

Thanks Ray!!!!

anbu wrote:Open Show Data Window in Data Management tool and select the partition you want to see the data

Anbu,

Can you please tell me what this data management tool? Do we need to get it installed separately?

Delimiter definedis Comma , and no rows are getting rejected My file has total 97 fields and first row is field name and same field name are values for that column .. for eg : G_QVVLBS,G_QVVIQT,G_QVVALT,G_AVV100 G_QVVLBS,G_QVVIQT,G_QVVALT,G_AVV100 1st row is name and 2nd row is values for that fiel...

you marked this topic as resolved. Can you please tell us what exactly you did?

make two stage variables first would remove leading zeros and second trailing: stage1 = trim(input,"0","L") stage2 = trim(stage1,"0","R") Here stage 2 is going to be your output variable. You don't need 2 fuctions to do that, just use trim with option 'B'. tr...

my i/p like this column 001 102 1300 00102 required o/p like this column 1 102 13 102 how to achive this one make two stage variables first would remove leading zeros and second trailing: stage1 = trim(input,"0","L") stage2 = trim(stage1,"0","R") Here stage 2...

sreddy wrote:Thank you for All

I fixed this issue.

Please specify the approach which you used exactly and mark the topic as resolved.

Hi All, I am trying to load some data to DB2 table and getting the following error: main_program: Error loading "orchdb2op": Could not load "orchdb2op": 0509-022 Cannot load module /data/ds/Projects/IBM/InformationServer/Server/DSComponents/bin/orchdb2op.o. 0509-150 Dependent mod...

if this is a date... use MonthFromDate and YearFromDate function to get values of yyyy and mm and use the function which arndw suggested.

What partitioning are you using on the inputs of the Join stage? ... At the beginning we had the "Same" partitionning, but as I sad before, we tried everything even passing the Join Stage in Sequential with both sides sorted. but you only said "The problem is that some of the records...

Hi All,

I want to create a custom stage which can perform function of transforming. Can anybody guide me how to accomplish it?