DSXchange

Hi Friends, Am trying to install IBM Infosphere Information Server v8.1 in windows env. But am getting the following issues. Kindly let me know how to proceed further. Thank You! My Hardware: Windows XP 2002 SP3/ 1gb ram / 75 gb harddisk Error: This is the error am getting at 5% of installation. I h...

Hi All, I have a dataset which is sorted and partitioned based on some columns. How to identify the columns that are used for partitioning in dataset as i dont know the job that creates this dataset. Is it possible to know the partitioning columns in dataset without looking into the job? If so, Plea...

Hi Chulett,

It would be really great if you could suggest the other way of doing this task.

Thanks,

Senthil Kumar P

Hi Arndw,

Thanks for your response.

I have done this using UNIX mkfifo - pipe to read from the file from other server and assigned this value dynamically to the dsadmin commands.

Thanks,

Senthil Kumar P

Hi All, I have a requirement such that, i need to FTP a file and pass that value inside the file to a dsadmin command. Important things is i shouldnt store the FTP file anywhere and i should dynamically pass the value to the dsadmin command. Will FTP stage followed by external target do this task. I...

Hi All, Am using the Stored procedure stage to load my sql server at the target end. When i execute the job it executes fine for 5000 records. When the records crosses 5000 the job aborts with the error message " Communication link Failure" Sql State 08S01 Please let me know how to resolve...

Thanks Ray for the info. Using the Stage info i could get the row count details. Stage info for the Dataset stages are not working. In my job i have more than one target dataset, if so how should i know the record count of my Target dataset. At least i want to get the record count of all the datsets...

HI All, How to execute a datastage job by folder wise using unix shell script(dsjob)? Eg., I want to run all the datastage jobs only under a particular folder Jobs/Customer(folder) for a project. Is it possible? Also how to find the total no of records passed on to the target Dataset or table thro u...

Ok, Thanks for the confirmation.

Thanks ArndW,

My target is database and the datatype we need is DATE. But the value to this should be like "20100210" without hypen.

Is this possible?

HI All, I want to convert the timestamp inp date to date type in output with the following format, Inp: 2010-02-10 02:30:40 Ouput i Need with date as datatype: 20100210 Using functions Timestamptodate and datetostring, i got 20100210 in the output but as string, when i give the datatype Date it incl...

HI All,

could you please suggest me the way to connect Progress Database via DataStage.

Is it possible thro ODBC? Or Is there any other stage that we have in Datastage to connect to the Progress Database.

Thanks,

Senthil P

Complete detail is available in the export file if you make sure to export properties that have default values and read-only components. ... Thanks Ray for the info. So i can get all the job details including transformation logics applied in the job export. Is this is not possible via querying the ...

Hi All, We would like to get the complete job detail from the DataStage Repository. Is it possible??? Detail in the sense for the given job i need source column - Transformation - Target columns. From the source till the target we need what are all the transformation been applied to the job. Will it...

Hi All, Thanks a lot for all your inputs. Finally this issue is resolved by Support Provider(IBM). We have to clean the project entries in UV file and then the Xmeta. We can clean it in UV but to remove the entries from Xmeta its look complex only they can solve this with the scripts. This is for yo...