Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

load from flat file into IQ

3 posts in General Discussion Last posting was on 2011-08-16 13:59:48.0Z
tartampion Posted on 2011-06-24 20:36:18.0Z
Sender: 17d4.4dff91a4.1804289383@sybase.com
From: tartampion
Newsgroups: sybase.public.iq
Subject: load from flat file into IQ
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e04f541.c04.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Jun 2011 13:36:18 -0700
X-Trace: forums-1-dub 1308947778 10.22.241.41 (24 Jun 2011 13:36:18 -0700)
X-Original-Trace: 24 Jun 2011 13:36:18 -0700, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4390
Article PK: 246530

the load table of IQ from a flat file works perfectly well,
but in a particular case where data being loaded from a flat
file coming from mainframe, we have problem with numeric
data. In the main frame flat files the numbers are defined
as -000000000021200021256. The field corresponding to this
number is defined as numeric (19,6) in the IQ table. the
load statement works well but instead of transforming the
number into "-212000.21256", it transform it to
"-21200021256.000000" which is not what is expected. help is
needed to reach the goal properly, please.
Tartampion


queryplande Posted on 2011-08-10 19:36:58.0Z
Sender: 6d1d.4e42921a.1804289383@sybase.com
From: queryplande
Newsgroups: sybase.public.iq
Subject: Re: load from flat file into IQ
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e42ddda.9fe.1681692777@sybase.com>
References: <4e04f541.c04.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Aug 2011 12:36:58 -0700
X-Trace: forums-1-dub 1313005018 10.22.241.41 (10 Aug 2011 12:36:58 -0700)
X-Original-Trace: 10 Aug 2011 12:36:58 -0700, 10.22.241.41
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4400
Article PK: 246540

Hi,

garbage out garbage in...
As there is no definition where the decimal point is
it looks like a big number.
3 possiblities:
1) Teach the host to write proper output.
2) Use some kind of skript to correct the output.
3) UPDATE column = column / 100000 after the load.

I never used a fixed length insert but connected two fields
(before and after the decimal point) to one value

> the load table of IQ from a flat file works perfectly well
> , but in a particular case where data being loaded from a
> flat file coming from mainframe, we have problem with
> numeric data. In the main frame flat files the numbers are
> defined as -000000000021200021256. The field corresponding
> to this number is defined as numeric (19,6) in the IQ
> table. the load statement works well but instead of
> transforming the number into "-212000.21256", it transform
> it to "-21200021256.000000" which is not what is expected.
> help is needed to reach the goal properly, please.
> Tartampion