DSXchange

Thanks to all, I have gone through the API Functions. But i want to create a routine which should return Elapsed time, Status, and Number of Rows. For no. of rows we can use below function typedef struct _DSLINKINFO { int infoType: / union { DSLOGDETAIL lastError; int rowCount; char *linkName; char ...

Hi

Can anyone advise me where i can get the Parallel Routines(C++) guide.

Thanks
Naga

ray.wurlod wrote:What do you mean by "validate"? Do you have specifications?

I need to check the file whether it has HEader/Trailer. As File has identifiers for each type of row. Eg: Header identifier : H as first character
Trailer:T
Details:D

I will post the sample data, i dont have it right now.

Hi

How do we validate the flat file whether the files are having headers, Trailers and Details. If any one is not there, job should get aborted.

Could anyone advise how do we implement this?

Hi

I ran the job in 4 node config file.

then if i tried to run the same job in 2 node file what will happen??

Could you please explain me a little bit briefly about this node changes.

Thanks & Regards
Naresh CH

Hi

If we have requirement that to extract the data from 2 tables ( both are in same schema) ....

which one will give the better performance

I mean query in DB2 stage or Join/Lkp in datastage ??

Any Help is appriciated..

Thanks
Naresh C

Hi

We are using CASE statement in DB2 query in DB2 stage ..But we are not sure which will give the better performance ( CASE or TRANSFORMER) ..

Any Help is appriciated...

Thanks
Naresh CH

Hi all, Could you please let me know how can I do a Date to Timestamp conversion. I have a job where I have a date format and need to convert to Time stamp format which is output format. I know we can do timestamp to date using TimestampToDate function. But iam not sure how we can do this. i would l...

Yes ray, I have created new job and used the same routine. I got the same compilation error. We haven't contacted the service provider yet. Process i have followed. 1. Created Server routine with the given code Call DSSetUserStatus(Arg1) Ans = Arg1 2. Created the server job and created Stage variabl...

Hi I got it. Below are log entries i found * Tokens were replaced below as follows: * V0S1.Stagevar%%1 <= USERSTATUS * Pin%%V0S1P1.Column%%1 <= DSLink3.Run_Number * GET.Pin%%V0S1P1 <= GET.DSLink3 * Pin%%V0S1P1.REJECTEDCODE <= DSLink3.REJECTEDCODE * Pin%%V0S1P2.Column%%1 <= DSLink4.Run_Number * PUT.P...

Thanks Ray, can you please tell where i can find the this log entries in Unix Server. we have many projects and had created many folder manually in our server. so i could not find any relevant folder for these files. Just for your information I had selected routine type as Transform Function. Is tha...

I have successfully compiled and able to test the routine as well. But problem is in Transfromer. Job is not getting compiled. showing the mentioned error message

I want to pass the value from file to Job parameter. I have created the routine as below (only 2 lines) and tried to assign the value to Stage variable.

My intention is to pass the value to Userstatus. then i can assign this value to job parameter

Thanks Ray,

Can you please suggest me how do we define and what to define?

Hi I have created the Server routine code: Call DSSetUserStatus(Arg1) Ans = Arg1 when i test it it is working fine. But when i call this from transfromer and it is giving compilation error. here Run_Number is the input column. nything else in Routine. I am calling theis routine from Server job onlyu.