DSXchange

Is there any function to that can be used in transformer to xonvert Binary datatype to Char datatype. Can we use iconv/oconv for this purpose

regards,
Santosh

Can someone help me in searching below A> some documentation to help me developing subroutines to be used in datastage EE 7.5.0 on UNIX. B> As per my info server routines can be written in Basic but for writing parallel routines we need to have C , C++ skills. Am i correct. C> Is there any separate ...

Any idea on how we can log a specific message in Datastage JOBLOG. Lets say I have a transformer and if a condition is not met I need to log message "Hi" in taht JOBLOG. How to go about it? I can see some routines present such as UtilityAbortToLog, UtilityGetRunJobInfo. But as per help it ...

In our project we require that after every job run we want its joblog stored in txt file. I tried to use After job Subroutine called DSJobReport to create txt file, but the report it gave was not exact replica of Director joblog. For eg. I tried to abort a JOB and compare txt file created with direc...

Thanks Ray, 1>I think I can intitialize the threshold calue in environment variable and get in transformer. Can I do that? 2> Can you please detail more about calling a routine. Lets take example of transformer stage. How do I call a routine that will act on every row. Also can you paste a sample ro...

My source file contains different record of different types. I am filtering records depending upon type field in different target files. My project needs functionality that 1> For a particular type of record if the record count exceeds threshold value the job shud abort. (threshold value is defined ...

Thanks Sachin, Store the o/p of xfmA in some temp file (which includes the value of xfmA Stage var), read it along with xfmA Stage var in xfmB. - Sachin Thanks Ray , Sachin: I was trying to assign a job variable in transformerA and use it in another transformerB which is not downstream to this stage...

You can't. Stage variable stays in the Stage. Ray's method is a good way. You can concatenate (with ":") any other value to it and propogate it downstream too. - Sachin Thanks Ray , Sachin: I was trying to assign a job variable in transformerA and use it in another transformerB which is n...

Is there any way where I can pass stage variable(transformer stage) to another stage in same job? Incidence in my job: I have to read a typical mainframe file having header, detail and trailer. In trailer there is count of detail records specific. My job needs to verify actual count of records with ...

thanks for your reply. I tried to do this with complex flat file stage but I was unable to change the format according to different record types. I posted the query in server as sequential and parallel file stage is present in both edition. Wanted to know if the architecture we are using is fine for...

SYSTEM: We have to develop job which will read Source EBCDIC files as per COBOL copybook layout, do transformations on some fields and then create an output EBCDIC file. We are using DataStage EE 7.5 parallel edition on UNIX to do this. PROBLEM: Our source files are coming from mainframe and has a ...

PROBLEM: We have to develop job which will read Source EBCDIC files as per COBOL copybook layout, do transformations on some fields and then create an output EBCDIC file. We are using DataStage on UNIX to do this. MANDATORY CRITERIA: We will be getting EBCDIC files from source and have to push targ...