DSXchange

Moral of the Story : Post New Topic link needs to be kept further apart from Reply to topic link.

I had to do the same for one of my clients. I ended up writing a macro for creating ddl from the spreadsheet, executed in a temp oracle schema and imported the metadata from there. The number of tables was pretty huge, so it was worth the one time effort :) PS : The tool was not Datastage, so there ...

Hi, I am planning to trial install Information Server on my dev box which already has 7.5x2. Did anyone try this or faced any issues in doing so? The installation guide mentions a Migrating to IBM Information Server Version 8 document which I am not able to spot in the download. I tried the save-to-...

another doubt i have after observing the job is : FTP stage is retrieving 23914 rows and after unzipping also i am getting 23914 rows in sequential file.after unzipping also can we have same number of rows as in zip file? :? What? There are no 'rows' in a zip file. ..... Though unix or mks toolkit ...

Hi, I am doing FTP the .gz file from unix server using ftp stage with ascii format and trying to unzip that using command stage using gunzip command .... I guess it boils down to this... A .gz file is a binary file. It needs to be ftp'd in bin mode(not ascii). Once you ftp it in ascii mode, the fil...

Hi Craig, Thanks for the input. That worked on the older db (DBMAIN), but failed for the newer one. Seems I need to run a CATALOG command which will make the ds server "aware" of the new remote database. Quite like creating aliases. PS : They are quite different from oracle schema. Differe...

Hi, I have a db2 instance DATASERV with two databases DBMAIN and DBHAWK. I am using db2/udb api to connect to DATASERV with user id(DSTAGE) and password. The generated query is SELECT STAGEPARAM FROM DSTAGE.PARAM WHERE.... My concern is that both DBMAIN and DBHAWK has PARAM table, so how do I define...

Hi All I have 16 .csv file which I have to laod from a Sequential file to another. the format is as followa:- SEQUENTIAL FILE(17 .csv files) ------>Transformer----------->Sequential file(1 big file) Can anyone help In your source sequential file stage, use *.csv [ or sufficiently narrow it down]. C...

chulett wrote:Are you using a supported compiler?

As Craig suggested, please check your compiler. I believe 2.96 is the g++ version supported on linux.
If you are on a unix machine, install the version and runtimes corresponding to your platform.