DSXchange

Got my answer, Thank-You!

Hi, Does version 7.5 allow both Server and parallel datastage edition to reisde on the same server? If yes, How can we configure to see both Server and Parallel projects through a common Administrator window. Is there any manual which describes Configuration for both edition on the same machine. Als...

I see the same error message on the Director : KgdGenHtmlJobDocs..JobControl (KgdGenHtmlJobDocs): JobReport(ADRP_LOOKUP_TABLE_SEQ,OutputDirectory,LogoPath,Style,Language) Attempting to Cleanup after ABORT raised in stage KgdGenHtmlJobDocs..JobControl After reading all posts I have checked: 1. Permis...

I see the same error message on the Director : KgdGenHtmlJobDocs..JobControl (KgdGenHtmlJobDocs): JobReport(ADRP_LOOKUP_TABLE_SEQ,OutputDirectory,LogoPath,Style,Language) Attempting to Cleanup after ABORT raised in stage KgdGenHtmlJobDocs..JobControl After reading all posts I have checked: 1. Permis...

Hi, I have a unix Script which uses dsjob for datastage Job Execution. I wanted to Know if there is there value in checking the RETURN_VALUE ($?) from the -run command? What does the $? return? What does -255 return code mean? OR Is it better to reinterrogate the -jobinfo for a status other than 0, ...

Server on which DataStage is mounted crashed.After restore get this error "very randomly" On Reset and Run, the same job works perfectly smooth. I searched this forum for this error and found possible reasons, but they dont seem to be the cause like: 1. rsh permissions. (nothing on rsh has...

I will try this out and update.
Thanks,
K-

I'm looking for a parallel function similar to convert.

My requirement is to change a matching input string (if found) to a output string defined.

convert does pretty much the same but for a single character and not for a string.

Any ideas or solutions are appreciated.

K-

There was an error in the Client side install provided for SAP Pack from IBM.
They sent me some new dll file and that resolved the situation.

Thanks

A typical scenario with Fixed width flat file will always represent NULL as spaces equal to the field length. DataStage will never consider space as a valid representation for NULL. I will do a Length after a Trim Validation to find out if its a NULL representation for a field or not. If Len(Trim(In...

SAP PACK, I have success in "VALIDATE" in SAP ABAP Stage. (CPIC) Could build a ABAP Code and load it into SAP. I am able to extract data. My Situation When I tried to write to a flat-file to read it in Notepad or Excel Sheet (csv) I am getting some wierd characters in Unicode and unable to...

I got the order

1. Repository
2. Domain
3. Engine

and Client and Documentation.

Is WAS available for Sun Solaris OS?

WAS is it part of installation or a pre-req I should plan?

Its been a tough path dealing with dates on different Databases. Working with similar situation, I adapt using user defined SQL or generate SQL with appropiate Conversion function. In a latest job (Using SQL Server), I used getdate() function to generate the system date. In another situation I used ...

I came accross same situation and solving it in Transformer used a constraint Len(Trim(somelink.somecolumn)) = 0. I had no gain in using IsNull() Validation but above logic worked fine. It works and simple. Since Transformer is parallel you still have performance enhanced. No, you need to filter the...