DSXchange

Hi, I will make it clear. We need to load data through Datastage(Installed on Windows) to DB2 DB (Installed on LINUX server). We know that we cann't connect directly to LINUX server from Datastage server installed on windows. Is it possible to to connect LINUX server through Datastage? Is there a wo...

Hi,

We are working on Datastage windows server. We have an requirement that we need to connect to UNIX server from Datastage sever installed on windows .

We need a work around to connect UNIX server from Datastage windows server?

Please let us know.

Thanks..

Hi,

When I am trying to load the data I am getting "ds_loadlibrary: Win32 error in LoadLibrary of oraoci9.dll - The specified module could not be found." error.

Can anybody let me know what could be the issue?

Thanks..

Hi,

We are loading data from windows to LINUX server. Currently it is going 9000 rows/sec. To load all data(230 M) it is taking ~8hrs. Is there a way to improve performance by tweaking the parameters in DB2 bulk load.

Note that target database is partitioned.

Can anybody help me on this?

Thanks..

Hi, We are loading data from windows to LINUX server. Data Stage resides on windows server and DB2 database resides on LINUX server. DB2 is also cataloged in windows server. SeqFile to DB2 (bulk load) I have selected following option in DB2 bulk loader to load to client server. Load from client : YE...

Hi, I need help on the following requirement. I have input in the following format. Input ----- A|B a|5 b|8 c|17 d|35 I need the output in the following format. I need to load B column data into new column (i.e. C) and push one row above. Output ------- A|B|C a|5|8 b|8|17 c|17|35 d|35| I know we can...

Thanks for the suggession. I can read data from excel, but how to execute macro which is being called in excel.

Can anybody help me on this?

Thanks

Hi, I have data in excel. I can convert the data into CSV format and read the data from DS Job. A macro is being called in the excel. When DS job runs, excel macro should execute along with the job on the data and write the data to output (text) file. Can anybody let me know how to call an excel mac...

Hi,

I have scheduled a job. When I run the job alone it is running without any errors.

But, when I schedule the same job and while running it is throwing following error.

"DSD.SEQOpen Failed to open DirPath\Filename.txt"

Could any one help me on this?

Thanks.

Hi,

We are reading data from an text file and load data to an XML output using XML output stage. The job is running successfully but, data is not getting generated to output file.

Source file --> Transformer --> XML output

Could anybody suggest the solution?

Thanks.

Simple could be, in constraint check for Right(column_name,4)=0000, then reject the rows.

Create a routine with the following code. Call the routine in wherever required. if Len(In.InputColumnName) = 2 Then Ans = In.InputColumnName:'000' else if Len(In.InputColumnName) = 3 Then Ans = In.InputColumnName:'00' else if Len(In.InputColumnName) = 4 Then Ans = In.InputColumnName:'0': else Ans =...

Hi,

I have defined set of environment variables in DS Adiministrator. For one of the variable I want to update the value. I am aware how to update manually for all the variables. But how to update automatically?

Is there a UV command to update a variable?

Can any body help me on this?

Thanks.

Hi,

I would like to know more information about REINDEX like

1. how frequently we can REINDEX on the whole project.
2. can we REINDEX if a hash file is corrupted.

I did a search on the forum but didn't much information.

Can anyone help me on this?

Thanks.

Output is as follows

Job name.............

product_seq
time_seq


Job name............


geography_seq
personicx_seq


Job name...........