DSXchange

Hi experts,

how can i know the RT_LOG number for a job?

Thanks in advance.

Hi experts, I have defined an ODBC connection to a SQL Server 2005. I'm executing a stored procedure using the ODBC stage and the performance is really slow (1 row per 3 sec). When i execute the Store Procedure from the MS SQL Server Management Studio the performance is (350 rows / sec) It seems to ...

Hi experts,

I'm trying to upgrade the Server release from 7.1.2r to 7.5.1 on an AIX server followin the documentation. But when i type ./install.sh and all the checks are done the screen displayed about installation and nothing about upgrade...

Could you, please, help me? Thanks a lot

Hi experts,

i have a float(16) field with the number like 59330897.3028773 but when i pass to a char(60) i loosing precision and i got 59330897.3029. What can i do?

Thanks in advance.

Hi, I'm facing a strange issue with the INROWNUM values. I have a routine call for the first row, this is done with the constratin @INROWNUM=1 after that all the rows will continue the processing normally. But for some reason the routine is never called because the @INROWNUM starts the count in 2. T...

Thanks for the quick answer DSguru2B.

I know i can do it using these two functions.

I just wan't to know wheter it's possible to do it using the Oconv or Iconv functions, and how to do it?

Thanks again :D

Hi experts, I'm getting from the database the value "0,8" and i want to multiply this number with another one. The problem is that i getting a phantom error because the decimal separator mush be . instead of , There is a way to do it using the Oconv or Iconv functions? I have tried with Oc...

Hi Kris,

it was the scale property of the column definition, once it's set correctly everything is fine.

Good point about the temp directory, that was causing the weird error.


Many thanks
Julio

Hi Kris, actually adding the temp directory seems to work fine. Now I'm having a different error: MergeTest..Sequential_File_3.IDENT1: Function 'get_next_output_row' failed Data length (1 bytes) is greater than column length (0 bytes). But i think this is due to column size problems. Thanks Julio

Hi guys, I trying to use the merge stage in a server job. First thing is I cannot drag input links to the merge stage. I guess it's because this stage doesn't need any link cause you specify directly within the stage the path and file you want to merge, but even without setting any input link the jo...

Hi guys, we're implementing several extracting jobs against DB2 databases. During the process there are several joins to be implemented. In the first attempt of creating a single lookup, the primary link was a select with a ODBC the reference link was a previously created Hash File (with the preload...

Hi collegages,

I would like to know if it's possible to install DataStage with a license number, and then change de license number with a new number without re-installing everything??


Thanks in advance
Julio

Hi all,

I would like to know if any of you has experienced with interaction between DataStage and DTS??


In this case we would like to invoke packages in DTS from DataStage jobs or sequences.


Thanks in advance
Julio

Hi, I'm wondering what it's the best solution for DataStage to call a remote program in another server. For example DS is installed in the server A and we have the program dtsrun in the server B. If a use a sequencer in the machine A and the I use the Commnad Stage, what is the best way of calling t...

Very good idea indeed,

but I'm thinking about the next stage after the OCI or DB stage. How if the columns names or datatypes are changing, then we have to use a table definition. How will we create dynamic table definitions also ??


Thanks the idea was veri good
Julio