DSXchange

True, The parameters donot work in the logon fields. But i guess the Support has informed that the parameters would work in the sql query.

Has anybody used parameters in sql query with CPIC mode of data transfer?

Regards,
Vinay

Hello, We are usign the SAP Extract plugin version 5.0 with DataStage 6.0.2. We have a problem while running the extract jobs using CPIC mode of DataTransfer. The jobs are running successfully when no runtime parameters are included in the select query. But when we use parameters in the select query...

Thanks a lot Ray!

Hello,

Is there any documentation available which can tell about the internals of DataStage?

Like for example, the internals of the stages or the details about how a typical job is executed.

Thanks and Regards,
Vinay

A px transformer is compiled with cpp compiler. You didn't post any compile time error so I presume it was compiled ok but ... probably when trying to load the shared object in runtime your environment (SHLIB or LD_LIBRARY_PATH) does not point to where this SO can be found. Maybe this is the reason...

I have a simple job with a transformer. When i try to run the job, i get the following error. "Transformer_2: Failed to load the library "VOS2_test_Transformer_2.so". Either the directory containing the library ........................................ " I have seen a similar post...

Hi all, We are using MQseries plugin to read the messages from Message Queue. The job aborts while reading from the message queue with the following error message. ********* UnloadXMLFiles..ExtractFileNameAndContent: Failed to read fixed-width column from message buffer. Reason code 6114. UnloadXMLF...

Hi,

Thanks a lot for ur time. The input from you will be very helpful.

Regards,
Vinay

Hi all,

Can u please tell me how can i access a database from the Job control Routine and query it using the SQL?

Thanks and Regards,
Vinay

Hi all, I have created some temporary hash files in my job and i need to delete them after my job. What is the exact procedure of doing this as the hash file consists of a directory and a file. Which has to be deleted first? And can we do this is one step using some routine? Could u please help me r...

Hi all, We have MQSeries and DataStage Server installed on a machine (Windows version). I need to retrieve data from the message queue from a different machine through the DataStage Client. DataStage says... Unable to validate user "112233". A required privilege is not held by the client. ...

Thanks a lot Ray...

We had contacted Ascential and it seems that it may be a bug.

Thanks for all the info about metadata mismatch.

Regards,
Vinay

Hi Ray, Thank you for ur time. This is the complete error message i got. DataStage Job 19 Phantom 1964 Program "DSP.ActiveRun": Line 51, Exception raised in GCI subroutine: Access violation. Attempting to Cleanup after ABORT raised in stage CopyOfpocXML..XMLInput1 DataStage Phantom Abortin...

hi all,

i am getting this error message :

Exception raised in GCI subroutine:
Access Violation

Can you please tell explain what this meassage means and what might be wrong?

Thanks and regards
Viany