DSXchange

Hi Ray, i open a cmd window and type telnet 127.0.0.1 and not connect, the cursor is waiting ...

In this case what is the solution???

Hi Forum, My DataStage server is running on Windows 2000, but i had to format and reinstal the OS and all programs, including DataStage. After the instalation i try login show me this error 'Failed to connect to host 127.0.0.1 (my pc), project : UV (The connection has timed out (81015)) All services...

Ok i will change the job and apply your recommendation.

Thanks.

Yes master, i verified and anylink is seted with that Update action. Is necessary separate in two diferents db2 stages or not?

Hi DSGuru,

This job has 2 links to the db2 stage, one for the insert and another for the update, i know there is an operation 'Update existing or insert new rows' or viceversa but im not using it.

Hi Forum, In my job process reads records from a sequential file and validate this record in a db2 table, if exists perform an updated operation else insert the new record. After run, in the director log appear this message 'DM_FCV_PROMEDIO..DB2_D_FCV_CONVERSION: This update action 'update or insert...

Hi, i had a similar error when insert record in oracle database, this error ocurrs when my field content a diferent date format with the db. You must to verify the database format and formatting your field in the transformer. Field Date_F = '01/03/2007' (my field) BD Date_F = '01-MAR-07' (db field )...

Hi Peter

Use the next data stage function

Formato = "R": Num_Decimals
Ans = FMT(Number, Formato)

In your case set the next values

Formato = 'R4'
Ans = FMT(0.77716666666667,'R4')

The result is 0.7772

I hope this help

Hi, I use the next sentence in my job : ALTER ROLLBACK SEGMENT RBS31 STORAGE ( OPTIMAL 4000M); SET TRANSACTION USE ROLLBACK SEGMENT RBS31; This will set in the tab SQL sub tab Before and work without problems. Now, after the job you must to restore the old rollback settings. I hope this help.

What is the function of this module ???

Is used to versioning jobs?? like SourceSafe ???

Hi Forum

I want to know how many and what Modules are in the new version of Data Stage (7.x) ,

Thanks for your help

Hi James,

Did you check the database date format???

When thats formats are different present this problems

I hope this help.

Hi Josy,

I think there isn't a function in DataStage for that , but i send a code that reverse any string ...

Cad = ''
For i=1 to Len(x)
Cad = x[i,1] : Cad
Next
Ans = Cad

I hope this help.

Hi,

This happen when you run a job???

Hi,

This message

Message : Cannot get exclusive access to log for job <jobname>

happend when the job was created using a different user, and you try to delete using other user that dont have permission..

Check your permissions in the directory.