SybaseIQ Bulk Load doesn't create .dat file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
uegodawa
Participant
Posts: 71
Joined: Thu Apr 27, 2006 12:46 pm

SybaseIQ Bulk Load doesn't create .dat file

Post by uegodawa »

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
uegodawa
Participant
Posts: 71
Joined: Thu Apr 27, 2006 12:46 pm

Post by uegodawa »

I contacted Ascential Support and got a patch for this issue. Problem has been solved.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Can you please post the eCase number, so others can get the same problem resolved more quickly?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
uegodawa
Participant
Posts: 71
Joined: Thu Apr 27, 2006 12:46 pm

Post by uegodawa »

e89448
Thanks,
Upul
Post Reply