TeraData Fastload Connection error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
dsrules
Premium Member
Premium Member
Posts: 76
Joined: Sun Nov 28, 2004 8:56 pm

TeraData Fastload Connection error

Post by dsrules »

Hi,
I am trying to load a table in TeraData using the Fast Load plug-in. the error is

Code: Select all

Unable to start FastLoad process fastload: system returns 2: The system cannot find the file specified
I could see the control file and data file being created in the specified directory. I could also load the TeraData table using the API stage, so that means the DSN is not a problem. I am presuming the DataStage Server is not able find the FastLoad exe, though the TeraData Load stage created the .fl and .dat files.
Any help is appreciated. Thanks
Mack
______________________________________
"Everytime I close the door on reality, it comes in through the windows." - Jennifer Yane
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Where is fastload.exe?

Is that folder mentioned in the search path environment variable (PATH)?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ldesilvio
Premium Member
Premium Member
Posts: 32
Joined: Thu Mar 27, 2003 6:38 pm
Location: Sewell, NJ

Post by ldesilvio »

I have the same problem. The fastload executable is in the path of the server DS is on. What else can I look for? Thanks in advance
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Just to clarify, I asked "where", not "what". :wink:
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
gdheatley
Participant
Posts: 10
Joined: Mon Aug 11, 2003 2:52 pm

What is the path?

Post by gdheatley »

Where should the PATH be set to, i.e. directory structure?
dsrules
Premium Member
Premium Member
Posts: 76
Joined: Sun Nov 28, 2004 8:56 pm

Post by dsrules »

The path variable should include this path

Code: Select all

C:\Program Files\NCR\Teradata Client\
dsrules
______________________________________
"Everytime I close the door on reality, it comes in through the windows." - Jennifer Yane
Post Reply