RE: SQL Loader Help in 8.1.6

2001-03-25 Thread Wendy Y
lto:[EMAIL PROTECTED]]Sent: Friday, March 23, 2001 2:47 PMTo: Multiple recipients of list ORACLE-LSubject: SQL Loader Help in 8.1.6 Dear Experts: This does not make any sense to me, can you help me out? I have a control file to interpret the mainframe data and then write to my table in Oracle Dat

SQL Loader Help in 8.1.6

2001-03-23 Thread Wendy Y
Dear Experts: This does not make any sense to me, can you help me out? I have a control file to interpret the mainframe data and then write to my table in Oracle Database. The mainframe data looks like "0}", The table is designed as Number(10,2), The control file use zoned(10,2). All

Re: SQL Loader Help in 8.1.6

2001-03-23 Thread Dennis Taylor
At 11:47 AM 3/23/01 -0800, you wrote: The mainframe data looks like "0}", The table is designed as Number(10,2), The control file use zoned(10,2). That looks like the internal representation for a signed number under COBOL. The least significant digit (LSD) is used to store the

RE: SQL Loader Help in 8.1.6

2001-03-23 Thread Aponte, Tony
2:47 PMTo: Multiple recipients of list ORACLE-LSubject: SQL Loader Help in 8.1.6 Dear Experts: This does not make any sense to me, can you help me out? I have a control file to interpret the mainframe data and then write to my table in Oracle Database. The mainframe data looks like