"A. Razzak Memon" wrote:
>
> Jim,
>
> 01. List all columns in Fourolk Table
Table: FourO1K No Lock(s)
No. Column Name Attributes
--- ------------------
------------------------------------------------------
1 ClockNo Type :
INTEGER
Index :
SINGLE-COLUMN
2 FrO1K_Wages Type : NUMERIC ( 9,
2)
Default:
0.00
3 FrO1K_Current Type : NUMERIC ( 9,
2)
Default:
0.00
4 Check_Date Type :
DATE
5 Hours_Worked Type : NUMERIC ( 9,
2)
Default:
0.00
6 Match_Period Type : NUMERIC ( 9,
2)
Default:
0.00
7 Loan_Pmt Type : NUMERIC ( 9,
2)
Default:
0.00
Current number of rows: 22231
>
> 02. What is the format of input file?
3148,865.73,.00,11/15/2001,53.00
3166,740.56,25.00,11/15/2001,47.50
3177,628.84,37.73,11/15/2001,47.50
3186,.00,.00,11/15/2001,.00
3246,732.88,21.98,11/15/2001,47.50
3311,550.94,.00,11/15/2001,47.50
3318,504.81,.00,11/15/2001,47.50
3327,383.33,.00,11/15/2001,28.50
3331,456.13,.00,11/15/2001,47.50
3332,577.71,.00,11/15/2001,46.00
3333,.00,.00,11/15/2001,.00
3334,580.13,.00,11/15/2001,53.00
>
> 03. What are the database CHARACTER SETtings?
BLANK
DELIMIT ,
LINEEND �
SEMI ;
QUOTES '
PLUS +
SINGLE _
MANY %
IDQUOTES `
>
> 04. You are missing "AS" option if loading from
> a simple ASCII file.
Just a typo.. I had it in my code
>
> 05. Any particular reason for using ;NOCHECK;FILL?
>
> FYI, NOCHECK turns OFF rule checking and FILL
> makes null any columns that have not been assigned
> values. All of the missing values must be at the
> end of the row. If a rule specifies that a column
> requires an entry other than null, do not use FILL.
The NOCHECK I was using to possibly suppress this bogus
error.. or whatever is wrong... The FILL I was using
cause the last two columns in the table are not within
the USING collist list...
I do see one thing I don't like in that the data has a
.00 instead of 0.00, but this has worked for years now
until I done the upgrade to 6.5++.. I should be able to
change this.
Jim Limburg
>
> Very Best Regards,
>
> Razzak.
>
> At 11:46 AM 11/13/2001 -0500, Jim Limburg wrote:
> >G-Day all
> >
> >I need to ping the GURU's on this one..
> >
> >Running this code:
> >
> >SET NULL -0-
> >LOAD fouro1k +
> >FROM &vg_chrfilepath USING clockno,fro1k_wages,fro1k_current,+
> >check_date,hours_worked ;NOCHECK;FILL
> >SET VAR var_interr = .errvar
> >IF var_interr = 0 THEN
> > PAUSE FOR 1 USING 'Technituft loaded' AT CENTER CENTER
> >ELSE
> > PAUSE FOR 1 USING 'Loading Error ' at center center
> >ENDIF
> >SET NULL ' '
> >
> >When this runs at run time... the PAUSE saying Loading
> >Error pops up...
> >
> >During trace errvar and var_interr stay at 0 (zero).
> >
> >The data is loading which is what's important here..
> >but I would like to be able to count on the error
> >variable to tell if it did..
> >
> >If all else fails I will go to using a SELECT to see
> >if the data go loaded, but I should have to..
> >
> >Has anyone seen this before..?
> >
> >By the way, when I was running this code in version
> >6.1a I was doing a
> >LOAD fouro1k +
> >FROM &vg_chrfilepath AS ASCII... and it was working fine..
> >There are two more columns that the amount of fields
> >that we are loading in.
> >Now that we went to 6.5++ I had to modify the code...
> >Upon a more detailed look at the Syntax I almost see why,
> >but there isn't a real good explanation of what parts of
> >the commands work with the new AS ASCII... or not?
>
> ===================================-============================
> R:BASE Developers's Conference: http://www.rbase.com/conference
> Official R:BASE List Server: mailto:[EMAIL PROTECTED]
> RBTI Events/Training: http://www.rbase2000.com/events
> R:DCC Members: http://www.rbase2000.com/rdcc
> ================================================================
> R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
> ==================================-=============================
