unable to connect to teradata

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
vzmz
Participant
Posts: 36
Joined: Sun Nov 23, 2003 12:10 pm
Location: Dallas

unable to connect to teradata

Post by vzmz »

Hi friends
I am new DATAStage. I have created a server job i select a teradata stage(I had 3 options 1-terdata_api 2- TeraData Load 3 - teradata multiload.) out of which i selected the API one i mention the terdata director and user name and password and i can pull any data i want.

Were as when i am trying the same stuff in a parallel job i have teradata stage in 2 option teradata Enterprise and teradata multi load. I opt teradata enterprise one but instead of asking teradata director it has server name and user name and password which after i specified gives me an error
Thanks in Advance
Following is the error i am getting
##I TFCN 000001 13:09:55(000) <main_program>
DataStage XE Parallel Extender V7.0.0
Copyright (C) 2003, 1997 - 2002 Ascential Software, Inc.
All Rights Reserved


##I TOSH 000002 13:09:55(001) <main_program> orchgeneral: loaded
##I TOSH 000002 13:09:55(002) <main_program> orchsort: loaded
##I TOSH 000002 13:09:55(003) <main_program> orchstats: loaded
##I TFSC 000001 13:09:55(004) <main_program> APT configuration file: /apps/opt/ascential/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 13:09:57(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TTER 000000 13:09:57(001) <Teradata_Enterprise_4> There should be a maximum of 1 occurrences of the "-table" argument, but got 2
>
Peytot
Participant
Posts: 145
Joined: Wed Jun 04, 2003 7:56 am
Location: France

Post by Peytot »

For Server, Ascential develop for us a Plug-in (TDMLOAD) which better then the Teradata Plug-in.
For PX, I don't think that the Ascential Plug-in perform. All the extract or Load that we have to do, do with Server and After we read the file in PX. I know that Ascential try to develop us a better Plug-in for Server.

See with them for PX, but .... good luck.

If you have more information, I would be interest.

Pey
Post Reply