DSXchange

Hi Eric I am also thinking the same solution. will be taking export to windows machine where I have DS client installed and then securely transferring file to unix box. Once this solution is up and running, I will reply to this thread. For now, marking this as work around. Thank you all for your res...

Hi we have a requirement where we need to get datastage job export on server itself and get dsx file as output. I could see istools which exports jobs in isx format. dsExport.exe (and/or dsexportcmd) are client based tools. but for my requirement, we need to get DS job export in dsx format at unix s...

aah....I answered it for DD-MON-YY format...

for this format, simple thing is to use:

StringToDate(DATE_COL,"%dd/%mm/%yyyy")

Thanks
Brajesh.

Can anyone please through some light on converting DD/MM/YYYY format to YYYY-MM-DD format in PX? You can use below format: StringToDate(DATE_COL,"%dd-%mmm-%1980yy") where 1980 is cut-off year. hence it will convert 03-MAY-99 to 1999-05-03 and 05-NOV-05 to 2005-11-05. Hope this helps. Than...

Problem with SQL Assistant is, it is based on ODBC drivers and hence uses ODBC APIs. To avoid this, you need to change the setting in SQL Assistant and then try running the query there. In SQL Assistant, Go to Tools -> Options and open Query tab. There uncheck the option for "Allow use of ODBC ...

Hi We have a requirement wherein we need to access iSeries (DB2) at As400 end from DataSatge. We have got iSeries Database catalogued on DataStage server. DS can use DB2 API stage but we have to create this job as Generic job which will have RCP turned on. We tried with DB2 Connector Stage but it fa...

I have put DB2 client ODBC driver name in .odbc.ini file. driver name: <path>/libdb2.a Now I am able to import the metadata (table definition) from DB2 database. Even I am able to view data from there. But when I am trying to run this in a job it is giving below error message: Message: Contents of p...

While reading at sequential file, you have to provide format for Timestamp. For field C1 in your case which is having value as 10-12-2010 00:00:00.0, format should be %dd-%mm-%yyyy %hh:%nn:%ss.1 and for C2 (values as 10-12-2010 00:00:00.00000), format should be %dd-%mm-%yyyy %hh:%nn:%ss.5 While prov...

Thanks a ton ppgoml...I followed the same method as per your post and could resolve the issue.

Thanks again.

Use: StringToTimestamp(<input Column Name>,"%dd-%mmm-%yy") This will take input as '17-APR-10' and output as 1910-04-17 00:00:00 Thanks Brajesh. But We need output as "2010-04-17 00:00:00' not "1910-04-17 00:00:00" Yes, missed that part. In this case you have to use Cut-off...

Use:
StringToTimestamp(<input Column Name>,"%dd-%mmm-%yy")

This will take input as '17-APR-10' and output as 1910-04-17 00:00:00

Thanks
Brajesh.

In target sequential file, set "First Line is Column Names" to TRUE. This will create column names in the file at the top.

Hi We have a requirement wherein we have to access tables in DB2 9v from DataStage 7.5.1 using ODBC stage. Seems ODBC driver version in DS7.5.1 does not support for DB2 9v. However Datadirect ODBC drivers 5.3 supports access to Db2 9v. Will we be able to install (rather upgrade existing) Datadirect ...

ray.wurlod wrote:Have you tried creating a synonym for the column name (in the database's table definition) and using that? ...

Hi

I can not creat a synonym for any object. I want to use this table only (No synonym/ views)..

We can't deal with "not working". It's inexact. Please post the exact error message that you get. Meanwhile consider creating a synonym for this column, where the synonym does not have any specia ... Hi Please find below the error message I got when tried to enclose column name within duo...