SybaseIQ Bulk Load doesn't create .dat file
Posted: Tue May 29, 2007 12:52 pm
Hi DataStage Guru's
I need your support regarding this issue.
I'm going to read data from sybase ASE table and insert those records into sybase IQ using IQ Load 12 stage.
Job Design :
SYBASE OC -> TRANSFORMER -> Sybase IQ 12 Load
This job will craete the .sql file but not the .dat file. Actually it will craete .dat file but size is 0 bytes.
O/S : Solaris
Sybase IQ/12.7.0/061017/P/ESD 1/Sun_svr4/OS 5.9/64bit/2006-10-17 22:23:42
Also I noticed that I've two options under the Property called 'Load Method' of Sybase IQ Load stage.
Those are
1. Manual Load
2. Autoload via OCOS (which I'm using now)
But 3. Autoload via ODBC is missing (even though manual says).
If anyone face same/similar issue or have any thoughts to resolve this issue would appreciate.
Thanks
Upul
I need your support regarding this issue.
I'm going to read data from sybase ASE table and insert those records into sybase IQ using IQ Load 12 stage.
Job Design :
SYBASE OC -> TRANSFORMER -> Sybase IQ 12 Load
This job will craete the .sql file but not the .dat file. Actually it will craete .dat file but size is 0 bytes.
O/S : Solaris
Sybase IQ/12.7.0/061017/P/ESD 1/Sun_svr4/OS 5.9/64bit/2006-10-17 22:23:42
Also I noticed that I've two options under the Property called 'Load Method' of Sybase IQ Load stage.
Those are
1. Manual Load
2. Autoload via OCOS (which I'm using now)
But 3. Autoload via ODBC is missing (even though manual says).
If anyone face same/similar issue or have any thoughts to resolve this issue would appreciate.
Thanks
Upul