DSXchange

Yes.

It is pointing to one of the links to the target table.But I checked that link and it is just like any other link into that table.

The error message is

"DSP.Open GCI $DSP.Open error -100."[/quote]

Hi

Im trying to insert records into a dynamic RDBMS stage using different links having the same metadata.

But Im getting an error "Error occurred during link open processing"

I checked the metadata for all links.They are the same.

What could be wrong?

thanks in advance

Hi all, i am facing an issue when i tried to run the job,it is getting aborting. the error message i am getting is like, "Fact_GH_F_XXX..DRS_GH_E_XXX: [Microsoft][ODBC Driver Manager] Invalid string or buffer length" This fact table design job lookup to some dimension tables,and if lookup ...

hi all,

how can i implement CASE Logic in datastage..

for ex: CASE when 'tan' then 'tango' when 'asc' then 'ascential'...like that

i hope it will wrks using 'if then else',but thinking to use CASE..


thanks in advance

Guys,

While trying to update a table(Dynamic RDBMS stage) Im getting an error
"Error occurred during link open processing.DSP.Open GCI $DSP.Open error -100"

Any idea what does that mean?

Thanks

can any one please respond !

hi Ray/Daniel, Thanks a lot for the response,i searched the forum and i found a related topic.can you please advise me whether the below mentioned variables are enough to define or any thing more i need to define? APT_TERA_SYNC_DAEMON_PROG = [server name for terasync table] APT_TERA_SYNC_DATABASE = ...

Hi Daniel,

Thanks for your quick reply.

But where can I find these parameters

(APT_TERA_SYNC_USER / APT_TERA_SYNC_PASSWORD / APT_TERA_SYNC_DATABASE )

Are they userdefined or system defined.I couldnt find it in the environment variable list.

Thanks,
Scorpion.

hi all, when i try to view data from Teradata stage after supplying necessary connection information,i am getting error like, Error executing View Data commanad: ##F TTER 000000 23:54:53(004) <main_program>FatalError: APT_TeraSync: could not create operator sync table can any one direct me to resolv...

how should i know some body monitoring my job..is there any process to get details of my job monitoring is currently from somebody?

hi

thanks for quick reply,but i am not monitoring the job in director.

how can i over come this problem.

hi all,

when i make some changes for source file and try to compile the job
it is giving error like

"cannot get exclusive access to executable file for job (jobname)
-job may be being monitered"


can any one helpme on this

thanks,

jason,

Is there any alternate way to achieve this without using shell scripts?
i need to run the jobs from jobsequencer..

Thanks kumar for your quick response!

what I want is:

Can I change/update the value of the job parameter within the same job.

Before job : Paramter X holds the value "1"

After job : Parameter X has to be changed/updated to "2"

how can i achieve this?

hi all, i want to change the value of userdefined environment variable,defined for a perticular job ,at run time in a jobsequencer. i want to assign a new value each time for that variable, whenever job runs in a job sequencer. how can i achieve this..can any one one help me on this? tx in advance!