|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/9/2007 12:00:00 PM
Posts: 1,
Visits: 1
|
|
Hi Swati,
.set quiet on might work for you.
Sharda
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/11/2009 4:12:52 PM
Posts: 4,
Visits: 18
|
|
Does anybody know how to suppress the same messages on a mainframe BTEQ?
Thanks,
Fernando Urrutia
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/7/2009 5:40:12 AM
Posts: 5,
Visits: 19
|
|
Hi,
Im trying to import data into tables from a file using BTEQ import.
im facing weird errors while doing this
Like:
if im using text file as input data file with ',' as delimiter as filed seperator im getting the error as below:
*** Failure 2673 The source parcel length does not match data that was defined.
or
if im using EXCEL file as input data file im getting the error as below:
*** Growing Buffer to 53200
*** Error: Import data size does not agree with byte length.
The cause may be:
1) IMPORT DATA vs. IMPORT REPORT
2) incorrect incoming data
3) import file has reached end-of-file.
*** Warning: Out of data.
please help me out by giving the syntax for BTEQ import using txt file as input data file and also the syntax if we use EXCEL file as the input data file
Also is there any specific format for the input data file for correct reading of data from it.
if so please give me the info about that.
Thanks in advance:)
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/7/2009 5:40:12 AM
Posts: 5,
Visits: 19
|
|
Some solution found out for the above query(Post #16675):
I've used the text file with data in which i used ',' as the field seperator and also the datatypes for all the fields in the USING clause are changed to 'varchar' irrespective of their original datatypes:
The code looks like this:
.LOGON TDPP/login_name,password
.import vartext ',' file = d:\input file path.txt
.QUIET ON
.REPEAT *
USING COL1 (VARCHAR(2))
,COL12 (VARCHAR(1))
,COL13 (VARCHAR(56))
INSERT INTO table name
( COL11
,COL12
,COL13)
VALUES ( :COL11
,:COL12
,:COL13
.QUIT
the code also works with fields seperated with a tab.
but it works only for
vartext ' ' (in the 2nd line of code)
but doesnt work for
vartext '\t'
|
|
|
|