DSXchange

Hi,

We are migrating the code from Ab Initio to DataStage EE 7.5.2. We have got following metadata from Abi and the file format is EBCDIC:
string("\307") aml_tran_cat;
string("\307") aml_tran_type; /* NUMBER*/
decimal("\307") sor_tran_type;
decimal("\307") R_COST_CENTER;
decimal("\307") co_id; /* NUMBER NOT NULL*/
string("\307") hard_code_product_code = 'DDA';
decimal("\307") acct_num; /* NUMBER NOT NULL*/
date("YYYYMMDD")("\307") post_dt; /* DATE*/
string("\307") tran_stmt_desc; /* VARCHAR2(100)*/
decimal("\307") tran_amt; /* NUMBER(14,2)*/
decimal("\307") led_bal; /* NUMBER(16,2)*/
decimal("\307") tran_seq_num; /* NUMBER NOT NULL*/
decimal("\307") check_serial_num; /* NUMBER*/
string("\307") dep_wd_cd; /* VARCHAR2(1)*/
decimal("\307") intern_gen_in; /* NUMBER*/
string("\307") operator_id; /* VARCHAR2(20)*/
decimal("\307") paper_in; /* NUMBER*/
string("\307") pcode; /* VARCHAR2(2)*/
string("\307") pd_into_od_cd; /* VARCHAR2(1)*/
string("\307") trace_id; /* VARCHAR2(20)*/
string("\307") sor_tran_cat; /* VARCHAR2(1)*/
string("\307") gli_source_cd;
string(1) newline;

Can anyone help me in selecting a proper metadata in DataStage in Sequential file stage?
I need to understand field and record delimeter from the given metadata which I can set in DS Sequential file stage.
Thanks in advance.

-Amit

Match the data types to the column names. The field delimiter goes in to the Sequential File stage, but must be given in decimal (that is, 199 in your example).

Hi Ray,

Thanks for your quick response. However, can you please elaborate it? I am not getting what you are trying to say. Do you mean I have to type the column names manually as given and select the given metadata. But for few columns, datatype is not given. Even I am not able to find \307 as field delimeter in DS Sequential file stage.

Thanks,
-Amit

You dou't have to type them in if you can import them from somewhere, such as an Oracle table or a text file. But there is no facility for reading a "metadata file" of the kind you describe.

You can enter a three digit decimal field separator - read the on-line help (you can also enter it in hexadecimal) - you don't necessarily have to choose one from the list.