DSXchange

As replied by other members for this task you don't need DS, but if you are eager to do that the easiest option is to use BeforeSubroutine or AftersubRoutine with ExechSh option.

Have anybody got the final answer ?

Many thanks for the information.

Hi All,

I have a parameter say 'A', which is defined at job level and sequencer level (both are having same name). If I modify this parameter at job level , will the value at sequencer level be modified ?

Hi,

Trasnaction size is present in the database stage. Check the db stage where you are writing the data.

Hi,

As per our report requirement we need to report data in XL format.

Is there any way to do this using DS job(using ODBC stage etc)
Or using the VB macro to convert .csv to .xls is the only option to acheive this?

Can anybody kindly get back on this question.

Thanks&Regards

[quote="UPS"]

You can pass the seq file value in the DS routine. The routime will set the parameter using 'DSSetParam ' function and call a job 'DSRunJob'.

Thanks.

I tried all the solutions given, but not succeeded yet

Maveric wrote:See if this link helps.

viewtopic.php?t=111557

That is for parallel job. but see if you can use it.

Hello All, I have one sybase table which contains one of the field having a datatype as 'Text'. I am using Sybase OC as a connective, while insertion of data into 'Text' field I am getting an error message as' ' Sybase Server warning 2782 (severity 16) from stored procedure 'Input_0', line 1: An unt...

Hi All, We are using DataStage7.5.1 server edition and the connective we used to connect with Sybase11.5.1 database is Sybase OC2.1. Now, we are migration to Sybase 15. Hence, not sure whether it will work with same Sybase OC2.1 or not. Can anybody know whether the same connective can be used with S...

We have recently migrated from the 7.1 to 7.5 in the test environment.
In the new environment, the property window of job activity stage in the sequence job is not opening.

Would it require running a patch.

GMIS_Mig was the actual name of the project in the verison 7.1 and we needed a new project on version on 7.5 also with the same name. And every time we added the new project it says the project already exists(though it was on veriosn 7.1) Anyways we have deleted teh earlier project :idea: and added ...

I have recently migrated from Datstage version7.1 to DS version 7.5 . We have a prject called GMIS_Mig in the version 7.1 but now I want to have a project in version 7.5 with the same name as GMIS_Mig because we dont' want to change the Unix scripts having the refernce to GMIS_mig project in teh ver...

Hi, We are in the process to upgrade the Datastage server engine from version 7.1 to 7.5, and the process has already taken a couple of hours. There is scheduled downtime of the unix server in a few hours from now. Can any please let me know how much time does it normally take for the datastage engi...

Display length is already defined and it is same as Length field.

sb_akarmarkar wrote:You need to set display lenght also


Thanks,
Anupam