Fastload from batch file

Tools & Utilities
Enthusiast

Fastload from batch file

Hello Everyone,

I have to create a fastload what imports data from an Oracle (8)database every day. I've created the amj file and the .fld file. (see the 00_cfm_data.fld and cfm.amj)

If I use the teradata Oleload application, loading will be succesful, but If I insert it into a .bat file it will give back the following message. (00_cfm_data.log!)

The batch file:

Echo Setting Rundate...
fastload < \Bud11Srv5223\Groups\Dwh\Application\jov_lists\00_cfm_data.fld > \Bud11Srv5223\Groups\Dwh\Application\Log\00_cfm_data.log

My operating system is Win XP SP2 and my oracle ODBC driver (MSDAORA) does not work, so I have to use MSDSQL drivers.

Could anybody please explain what was my fault?

Thanks in advance!
2 REPLIES
Enthusiast

Re: Fastload from batch file

===================================================================
= =
= FASTLOAD UTILITY VERSION 07.06.00.000 =
= PLATFORM WIN32 =
= =
===================================================================

===================================================================
= =
= Copyright 1984-2004, NCR Corporation. =
= ALL RIGHTS RESERVED. =
= =
===================================================================

**** 10:02:06 Processing starting at: Tue Mar 14 10:02:06 2006

0001 .SET SESSION CH****T "ASCII";

**** 10:02:06 Command completed successfully

===================================================================
= =
= Logon/Connection =
= =
===================================================================

0002 LOGON hunccp/hunccp_mmo,

**** 10:02:11 Current CLI or RDBMS allows maximum row size: 64K
**** 10:02:11 Character set for this job: ASCII
**** 10:04:24 CLI Error 301: CLI2: SESSOVER(301): Exceeded max number
of sessions allowed.

**** 10:04:28 Number of FastLoad sessions connected = 298
**** 10:04:28 FDL4808 LOGON successful

0003 DATABASE hunccp_fls ;

**** 10:04:28 Command completed successfully

0004 drop table "d_cust_licenses";

**** 10:04:32 Command completed successfully

0005 CREATE TABLE "D_CUST_LICENSES" ( home_store_id DECIMAL(7,0) NOT NULL,
CUST_NO DECIMAL(12,0) NOT NULL,

LICENSE_SYS_TYPE VARCHAR(6) CHARACTER SE
T LATIN NOT NULL,
LICENSE_SYS_NO VARCHAR(90) CHARACTER S
ET LATIN NOT NULL,
VALID_FROM TIMESTAMP(0) NOT NULL,
VALID_FROM_DATE DATE NOT NULL FORMAT 'Y
YYY-MM-DD',
VALID_FROM_TIME FLOAT NOT NULL FORMAT '
99:99:99',
VALID_TO TIMESTAMP(0) NOT NULL,
VALID_TO_DATE DATE NOT NULL FORMAT 'Y
YYY-MM-DD',
VALID_TO_TIME FLOAT NOT NULL FORMAT '
99:99:99',
DL_ID DECIMAL(1,0) NOT NULL,
SPECIAL_TAX_NO VARCHAR(90) CHARACTER S
ET LATIN,
MGE_CAT_ID DECIMAL(3,0),
ASSORT_SECTION_ID DECIMAL(1,0) ) ;

**** 10:04:34 Command completed successfully

0006 BEGIN LOADING "D_CUST_LICENSES"
ERRORFILES D_CUST_LICENSES_errors1, D_CUST_LICENSES_errors2
INDICATORS ;

**** 10:04:34 Indicator mode is set to ON
**** 10:04:40 Number of AMPs available: 476
**** 10:04:40 BEGIN LOADING COMPLETE

0007 AXSMOD Oledb_Axsmod "noprompt";

**** 10:04:40 I/O Error on Open: 3, Text: Requested Access Module not
found
**** 10:04:40 Error: Invalid pmHandle parameter
**** 10:04:40 Error: Invalid pmHandle parameter
===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================

**** 10:04:40 Logging off all sessions
**** 10:07:44 Total processor time used = '5.34375 Seconds'
. Start : Tue Mar 14 10:02:06 2006
. End : Tue Mar 14 10:07:44 2006
. Highest return code encountered = '12'.
**** 10:07:44 FastLoad Paused
Enthusiast

Re: Fastload from batch file

Hi,

the problem was the batcf file, because I had to correct it as following:
Path C:\Program Files\Common Files\NCR\AXSMOD;C:\Program Files\NCR\Teradata Client\Bin;%PATH%;

Echo Setting Rundate...
fastload < \\Bud11Srv5223\Groups\Dwh\Application\jov_lists\00_cfm_data.fld > \\Bud11Srv5223\Groups\Dwh\Application\Log\00_cfm_data.log