DSXchange

Hi, I am getting error in running a job with Java client stage.Below are the Error Message:- guid,0: Fatal Error: Fatal: TJClient::initialize: unable to create Java Virtual Machine; classpath = /opt/IBM/InformationServer/Server/DSEngine/java/lib/tr4j.jar ASCL-DSJNI-00011`:`JNIWrapper: load library f...

Hi,
Yes it is possible.Design a job with source as Sequential file stage and in column tab define Varchar(2000).
Remove delimiter options from seqential file stage,so stage will read entire row as a one single string.
In transformer apply field function to get 3ed,6th and 9th field.

Thanks
Prasoon

Hi, Your example is for Vertical Pivot.Vertical Pivot stage is working in Datastage 8.7.Your example has dynamic changes in grouping of key(ID) records,so i am not sure if it will work with Pivot Stage but you can try. In Pivot Stage:- Define ID column as Group By column in Stage tab, Define Value c...

Hi Ray,

This solution is working,thnaks for your reply.


Thanks
Prasoon

Hi Ray,

Thanks for your prompt reply.Yes i mean to say pass the output from the routine.

Thanks
Prasoon

Thanks ray for your reply.So better i am thinking to go for delete the commited data in case of batch failuar,but i am not sure how delete will perform on millions records,so in your view what will be best apporach to handle the batch fail.

Thanks
Prasoon

Hi,

I need to handle the exception in case of load failed.Can i implement in datastage like ,i can commit the database once load get finished successfully otherwise if it get failed in between,i have to rollback.

Any suggestion.

Thanks
Prasoon

Hi,
How can we add this header in C++ compiler on unix env.

Hi, I tried to find work around with writing a C++ code, below is the code:- #include </uuid/uuid.hpp> #include <stdio.h> #include <stdlib.h> char* UUID_GEN() { char* uuid; uuids = uuid_generate(); return uuid; } But while compliation its giving below error message:- ", line 1.10: 1540-0836 (S)...

Sorry,not able to see the premium content,any one has done this in datastage,please suggest.

Thanks
Prasoon

Hi,
We have requirment to create GUUID ,is there any fuction or routine in datastage that will create it,acutally we can't call oracle or any database function here.
We can call c++ routines,unix script or java functions,so can anyone help us to achieve this by any of above ways.

Thanks
Prasoon

Hi,

This can be easily done by using Pivot Enterprise stage and using vertical pivot option in DS 8.7.

Keep KeyCol as Group By and rest columns as pivot option and make Array size as 3.

After pivoting you can put transformer stage to achieve your goal.

Thanks
Prasoon

Hi,
This can also be achieved by using transformer and funnel stage.
In output tab of transformer take 4 links.In every link write below derivation,

Link1:- field(in.col,",",1)

Then funnel all links that will be your desired output.


Thanks
Prasoon

I have already selected procedure type as source

Hi,

Till now i have not opened a case with support,althought its showing with the error,but all servises are seems to working properly in operational consol.