DB2 Data load

kishpra · New User Joined: 24 May 2010 Posts: 92 Location: Pune

I am going to load the DB2 table which has column as BILLING_DET DECIMAL(15).

The input file for the load job (SYSREC) has data in the format below:
Text-Data CHAR(15) VALUE = +000023400000

How can I store the sign in BILLING_DET column of DB2 table.

Akatsukami · Posted: Tue Mar 01, 2016 10:32 pm Post subject:

Numeric DB2 columns are always signed; you need do nothing.

kishpra · New User Joined: 24 May 2010 Posts: 92 Location: Pune

'Numeric DB2 columns are always signed; you need do nothing.'

It does not work as negative sign is not loaded into DECIMAL field.

So please let me know how can I perform the below:

I am going to load the DB2 table which has column as BILLING_DET DECIMAL(15).

The input file for the load job (SYSREC) has data in the format below:
Text-Data CHAR(15) VALUE = -000023400000

How can I store the sign in BILLING_DET column of DB2 table

Akatsukami · Posted: Wed Mar 02, 2016 5:25 am Post subject:

How do you know that the sign is not being carried by the DB2 column? Have you retrieved it into a numeric edited field?

kishpra · New User Joined: 24 May 2010 Posts: 92 Location: Pune

My query is for Load job only. I am getting an input PS file with AMT-FIELD in CHAR(15) format with first character as sign and then loading that file into a DB2 table with AMOUNT field defined as DECIMAL(15)

PeterHolland · Posted: Wed Mar 02, 2016 2:52 pm Post subject:

Bill Woodger · DFSORT Moderator Joined: 09 Mar 2011 Posts: 7314

The question was, rephrased, can you confirm that after the load you have verified whether the sign on the data in the DB is correct.

kishpra · New User Joined: 24 May 2010 Posts: 92 Location: Pune

I am getting an error wile loading Text field like '-00000393939' into DB2 DECIMAL column. Please advise.

Bill Woodger · DFSORT Moderator Joined: 09 Mar 2011 Posts: 7314

Things on the Mainframe are usually more specific than "an error". There are probably many thousands of ways you could get "an error". Without detail (the control cards and full message details) there's not much to be done.

kishpra · New User Joined: 24 May 2010 Posts: 92 Location: Pune

Error:

'BMC51501E INVALID NUMERIC DATA, COLUMN = 'TOT_AM', RECORD NO. 1 OF SYSREC, DATA = X'4EF0F0F0F0F0F0F0F0F0F0F0'

enrico-sorichetti · Posted: Wed Mar 02, 2016 4:53 pm Post subject: Reply to: DB2 Data load

why not read the manuals for the utility being used to find out the formats for the different data types ?

topic is going to be locked if the attitude does not change