DSXchange

Hi

I'm having a senario to develope a logic/code/job to capture JobName, StartTime, EndTime and ElapsedTime of job from job log and have to write it into a file.

Please suggest me any idea? I've an idea to use dsjob -loginfo. But it requires script.

Thanks,

Hi All, Could some explain me how the routine UTILITYHASHLOOKUP will work? How to pass the arguments? * Input Parameters : Arg1 = Hash Table Name Arg2 = Hash Key Value Arg3 = Column Position to return. If empty, return entire row in a dynamic array. My doubt here is, in ARG2, do we need to provide c...

Hi... When I run the job it is giving the following warnings ========== main_program: **** Startup error on node1 connecting with conductor on COMPNAME with cookie 1276456058.429000.1628: unable to connect to port 10000 on conductor; socket = 4, Connection refused retries left: 3 main_program: **** ...

Hi I installed DS 7.5.2 on Windows XP Professional. Its for my practice. While trying to accss the data with Sequential file and tried view data, I'm getting the following error... =================================== Error : ##I TFCN 000001 00:01:24(000) <main_program> Ascential DataStage(tm) Enterp...

I'm sorry. I opened a new topic.

One of my job is failing with the following error Error -4 getting details for event 2695779 Error -4 getting details for event 2695778 Status code = -4 DSJE_BADVALUE Abnormal termination of stage JOB_NAME..TRANFORMER_STAGE detected After processing of 1347887 records it is failing with 2695781 warn...

Hi chulett, Before to reindex I check for the open connections. Otherthan mine no connections are there. Even I closed all the connections, it is showing in current open connections. When I checked ps -ef, no process exist. So I did REINDEX and no job is visible. So I decided to do restart of DataSt...

Hi All Again,

I'm sorry to put one more point that I've tried DS.REINDEX.ALL. But not sure from where and how to execute this.

Please help me. Thanks...

Hello All, Greetings of the day. I did imported the job. After that I tried to REINDEX the project with dsadm user. After doing the REINDEX, I'm not able to see any jobs. Let me put how I did, From Project folder I execute $(</.dshome)/bin/uv Server.dsadm:/serverpath/PROJECT_NAME> $(</.dshome)/bin/u...

Hi

Please let me know the importent things which needs to be taken care while upgrading the DataStage Version from 5 to 7.X!. How to make estimations in hours?

thansk in advance for your valuble inputs.

Regards

Hi chulett,

Thanks for your support. I just removed the Jobnames as I shouldn't do it. And yes, after the "error text is" nothing is there.

Moreover the issue is now resolved after copying .odbc.ini of version 5.3 to DSEngine. Earlier there was lower version file.

Once again Thanks

I've not modified the log. Just replaced the jobname and Database name. Let me explain you real situation, I opened the job and tried to view the data in both the stages and I'm able too. When I run the job, it is giving the above error and aborting. Can you tell me, will the below link helps http:/...

Sorry for my mistake.

I'm using DataStage 7.5.3 with ODBC drivers version 5.3

I'm using ODBC, DB2 stages. The job is given the log as I mentioned in earlier post. otherthan that no information in log. I'm able to see the view data from stage but failing to run the job

Hi.. I'm new to this tool. To seems this question may be silly to most of the users. But I'm helpless as I'm niew. Please help me. One of my job is failing sue to the error " JOBNAME..JobControl (fatal error from ): Cannot connect to source database: DSN = DATABASE_NAME, user = USER_NAME. Error...