Hi experts,
I have tried to use the named pipe for fastload using the np_AXSMOD.dll as indicated in the document, however, it failed, do you have any idea about the errors?
I/O Error on Open: 34, Text:
Error: Invalid pmHandle parameter
my script and log attached.
Thanks!
Bun
================== Script ===============
.SET SESSION CHARSET "ASCII";
LOGON adwdev/dev_adw_bat,xxxx;
DATABASE dev_adw ;
BEGIN LOADING "AIRTM_BRKDN_REF_ODS"
ERRORFILES AIRTM_BRKDN_REF_ODS_e1, AIRTM_BRKDN_REF_ODS_e2
CHECKPOINT 5000000 INDICATORS ;
axsmod np_AXSMOD.dll "fallback_directory=....";
define file=\\.\pipe\mypipe...;
INSERT AIRTM_BRKDN_REF_ODS.*
END LOADING;
LOGOFF ;
================== Script ===============
================== Log ===============
===================================================================
= =
= FASTLOAD UTILITY VERSION 07.06.00.000 =
= PLATFORM WIN32 =
= =
===================================================================
===================================================================
= =
= Copyright 1984-2004, NCR Corporation. =
= ALL RIGHTS RESERVED. =
= =
===================================================================
**** 14:48:52 Processing starting at: Wed Jun 14 14:48:52 2006
0001 .SET SESSION CHARSET "ASCII";
**** 14:48:52 Command completed successfully
===================================================================
= =
= Logon/Connection =
= =
===================================================================
0002 LOGON adwdev/dev_adw_bat,
**** 14:48:56 Current CLI or RDBMS allows maximum row size: 64K
**** 14:48:56 Character set for this job: ASCII
**** 14:49:00 Number of FastLoad sessions connected = 7
**** 14:49:00 FDL4808 LOGON successful
0003 DATABASE dev_adw ;
**** 14:49:00 Command completed successfully
0004 BEGIN LOADING "AIRTM_BRKDN_REF_ODS"
ERRORFILES AIRTM_BRKDN_REF_ODS_e1, AIRTM_BRKDN_REF_ODS_e2
CHECKPOINT 5000000 INDICATORS ;
**** 14:49:00 Indicator mode is set to ON
**** 14:49:05 Number of AMPs available: 7
**** 14:49:05 BEGIN LOADING COMPLETE
0005 axsmod np_AXSMOD.dll "fallback_directory=....";
**** 14:49:05 I/O Error on Open: 34, Text:
**** 14:49:05 Error: Invalid pmHandle parameter
**** 14:49:05 Error: Invalid pmHandle parameter
===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================
**** 14:49:05 Logging off all sessions
**** 14:49:07 Total processor time used = '0.791138 Seconds'
. Start : Wed Jun 14 14:48:52 2006
. End : Wed Jun 14 14:49:07 2006
. Highest return code encountered = '12'.
**** 14:49:07 FastLoad Paused
==================== Log ===================
I have tried to use the named pipe for fastload using the np_AXSMOD.dll as indicated in the document, however, it failed, do you have any idea about the errors?
I/O Error on Open: 34, Text:
Error: Invalid pmHandle parameter
my script and log attached.
Thanks!
Bun
================== Script ===============
.SET SESSION CHARSET "ASCII";
LOGON adwdev/dev_adw_bat,xxxx;
DATABASE dev_adw ;
BEGIN LOADING "AIRTM_BRKDN_REF_ODS"
ERRORFILES AIRTM_BRKDN_REF_ODS_e1, AIRTM_BRKDN_REF_ODS_e2
CHECKPOINT 5000000 INDICATORS ;
axsmod np_AXSMOD.dll "fallback_directory=....";
define file=\\.\pipe\mypipe...;
INSERT AIRTM_BRKDN_REF_ODS.*
END LOADING;
LOGOFF ;
================== Script ===============
================== Log ===============
===================================================================
= =
= FASTLOAD UTILITY VERSION 07.06.00.000 =
= PLATFORM WIN32 =
= =
===================================================================
===================================================================
= =
= Copyright 1984-2004, NCR Corporation. =
= ALL RIGHTS RESERVED. =
= =
===================================================================
**** 14:48:52 Processing starting at: Wed Jun 14 14:48:52 2006
0001 .SET SESSION CHARSET "ASCII";
**** 14:48:52 Command completed successfully
===================================================================
= =
= Logon/Connection =
= =
===================================================================
0002 LOGON adwdev/dev_adw_bat,
**** 14:48:56 Current CLI or RDBMS allows maximum row size: 64K
**** 14:48:56 Character set for this job: ASCII
**** 14:49:00 Number of FastLoad sessions connected = 7
**** 14:49:00 FDL4808 LOGON successful
0003 DATABASE dev_adw ;
**** 14:49:00 Command completed successfully
0004 BEGIN LOADING "AIRTM_BRKDN_REF_ODS"
ERRORFILES AIRTM_BRKDN_REF_ODS_e1, AIRTM_BRKDN_REF_ODS_e2
CHECKPOINT 5000000 INDICATORS ;
**** 14:49:00 Indicator mode is set to ON
**** 14:49:05 Number of AMPs available: 7
**** 14:49:05 BEGIN LOADING COMPLETE
0005 axsmod np_AXSMOD.dll "fallback_directory=....";
**** 14:49:05 I/O Error on Open: 34, Text:
**** 14:49:05 Error: Invalid pmHandle parameter
**** 14:49:05 Error: Invalid pmHandle parameter
===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================
**** 14:49:05 Logging off all sessions
**** 14:49:07 Total processor time used = '0.791138 Seconds'
. Start : Wed Jun 14 14:48:52 2006
. End : Wed Jun 14 14:49:07 2006
. Highest return code encountered = '12'.
**** 14:49:07 FastLoad Paused
==================== Log ===================