DSXchange

You can read the entire record in a single field as varchar-assign some large field length, then use column import stage and define the schema file and in target sequential stage use '|' delimiter. You must enable RCP at job level. You must have subsequent jobs that reads the above output files, in ...

Hi All, Want to confirm one scenario that I am facing. Currently in DEV environment, RCP is enabled in project level(the check box is ticked in administrator). In QA and Prod environment, the RCP check box is not enabled but the the option extend link propagation(just underneath RCP checkbox is chec...

Hi All,

This issue is resolved. Thanks.

Hi All, Have a requirement to load around 10 source data(from sybase) to oracle staging layer as a direct dump. Want to create one single generic job to load the data and use multiinstance to invoke them in sequence level. Enabled RCP at job level. Job Design: ODBC stage--------Transformer stage----...

Thanks Craig. I set up cut off year as 2000 and received the desired output.

ok, then may be my expression is wrong hence getting parsing error.

If I want to extract cutoff year from the input field, I am using expression as below:

StringToDate(InputLink.Datestring,"%NNNNyy")

I am getting parsing error for this.

Thanks Craig,

To use date tag, do I need to use basic transformer?

Hi All, I have a requirement to convert input string to date fomat yyyymmdd. Input string is coming as 'yymmdd' format. Ie if input data is 190110, output should be 20190110. I used the following conversion: DateToString( StringToDate(Lnk_TDCO.TRAIL_DATE,"%yy%mm%dd"),"%yyyy%mm%dd"...

Hi All, I have a following requirement. I need to access a Table which is in a SAS SPDS library. Can you kindly guide me how do I connect to the SAS library from datastage to get the data out of that table? Can I use SAS stage to read the table from library? To access SAS library, do I need to have ...

Hi Frank,

Atlast, the mainfrate team has agreed to push the file to ETL server.

So, I am not extracting the file from mainframe.

Hi Ray,

I used StringToRaw function to to check the values. How can I identify whether it is a double byte character?

Hi Ray, The NLS map is set to Project default(UTF-8). I used following derivation in the transformer and those characters were not seen. Trim(Trim(DSLink3.RDT_ADDL_SEG_KEY_PROD,char(24)),char(26)) I used 24 as Dec representation for hex 18 and 26 is Dec representation for hex 1A. Is that approach ok?

Hi All, I am reading a cobol EBCDIC file using CFF stage and loading it into Sequential file stage. There are 2 fields defined in CFF as PICX(2) and PIC X(1) which is in Record Layout shown as CHARCTER 2 and CHARACTER 1 respectively. I directly mapped those 2 fields to sequential file stage using da...

Thanks Frank.. I think this approach will not work for my case as the the binary file is variable length file and if I output as one continuous record then I cant read it...This approach would have worked in case of true Fixed width file. Currently I am reading the file (test file pushed to datastag...

Hi All, I am reading binary file(EBCDIC format) through CFF stage and writing to a sequential file in "^" delimited which will be consumed by downstream application. The down stream application will read the file and load as is into a Hive table in HDFS and all the fields type are string. ...