DSXchange

Its having just two transformers and STP stage.

Hi I got the following warning in one of my jobs run and my job got aborted. "Abnormal termination of stage Load_Status..Xfm_Stg detected" I had reset the job and found the following information from job log. "From previous run DataStage Job 324 Phantom 22349 jobnotify: Unknown error ...

Hi William,

Really Thanks for your response. I will contact the support provider .


Thanks

Hi ,

Thanks for your response.I have provided space before and after. Ok i will ask my adminstrator to check for the INFORMIX driver. But what is the error in case of SQLSERVER 2005 too... for that also i added entries in odbc.ini and uvodnc.config ( Project level)

Thanks

Hi i guess i am using the same driver you mentioned. FYI [Bostontest] QEWSD=39298 Driver=/dss/Ascential/DataStage/branded_odbc/lib/VMifcl20.sl Description=DataDirect Informix Wire Protocol Database=promotion LogonID=testpro Password=testpro9 ServerName=bonny HostName=164.52.240.96 Service=1598 Proto...

Hi,

Thanks for your reply.I even tried with these two drivers shipped by datastage.

Informix=DataDirect 5.0 Informix
Informix Wire Protocol=DataDirect 5.0 Informix Wire Protocol

the informix database is of version 9.x ...


Thanks

Hi, Before posting i have searched the forum by using the key word DBMSTYPE and found useful information regarding ODBC connection.From that i was able to set up the connection but still iam getting the error. Iam trying to set up two database connections through ODBC. One is source SQLServer 2005 w...

Hi,

You mean all those files and hash files which were designed in unix server should Ftp to windows server rite?

Thanks

Hi Everyone, Before posting this message i have searched the forum. Currently some jobs are running on Version 7.5.2 on Unix Server i need to migrate those jobs or whole project to new version 8.0.1 on windows server. Could you tell me what are the steps do i need to consider while migrating safely ...

Hi Ray, Thanks for the reply. Iam using Informix CLI stage as target . If i run the same job the job is getting aborted and the error message is as follows. Attempting to Cleanup after ABORT raised in stage CopyOfBostonDatabase2..Informix_CLI_33 DataStage Job 200 Phantom 3848 Program "DSP.Open&...

Hi

I would like to know whether there is any way to restart the job sequence form the point of failure using Crontab.
i did it once but its not working. Are there any other things to be taken care of.
We donot want to use director to restart

Thanks
Sunil

Hi Everyone, I have developed a job, which select records from table and inserts into other table. Here the source is sqlserver in one location and target is Informix on unix in different location.I have used ODBC stage for both source table and target table. I have transformer stage for mapping the...

Hi , I am getting the correct output data. i dont know whether i have done in correct manner or not . The way i did was, I ftp the sequential VSAM file to my datastage server in binary format. The options i set in CFF stage are NLS:Project Default( None) Dataformat: NLS Record Style: Binary Record L...

Hi Craig,

The source file outside the datastage is in Binary format .

I have the same source file in ASCII format also .

Could you please suggest me how to solve this issue ..I have been trying this for a long time but couldnt find the solution.


Thanks

Hi,

I couldnt see IBM 01141 in loaded maps only.

i have EBCDIC IBM 1141 IN SHOW ALL MAPS

Thanks