EBCDIC file with \307 delimeter

[Amit Jaiswal]

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

[ray.wurlod]

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).

[Amit Jaiswal]

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

[ray.wurlod]

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.