DSXchange

May I know the Difference between DB2 API stage and Enterprise stage based on Authentication? For the ID that we use to run and connect the DB, We have the Login=False setting in the DB server for a Reason. With this, Enterprise stage is working, but not the API. API is giving out the error as User ...

Is there a Beta version of 8.5 available for download and try in PC for free?

One Engine node and multiple Resource nodes.
Like wise, we have Dev, Test, Prod Environments.
There are couple of servers set (Datastage Instance) for each environment.

Hi guys,

We would be converting our server settings from rsh to ssh setup.
For better security purpose.
In Datastage standpoint, what are all the settings and configuration that I need to take care of?
Server OS is Linux.
Database: Oracle, DB2.

Thanks in Advance!!

I can add escape character only for one value
eg: /'23423423/'

And not as

Iam passing values such as '234234','3453453','45645645' to a varchar field in ODBC stage as follows in the Where clause column1 in #Jobparameter# Its giving wierd erros, sometime core dump. If i pass the value as '23423' (single value), it works. If I pass multiple integer value 23423,456456,56756 ...

Thanks course.
After exporting Lib path it worked. I guess it was never in dsenv nor in .profile.

Hi, Iam trying to access orchadmin command from command prompt. It gives the following error. ##E TFPA 000021 $APT_CONFIG_FILE was not set, and config.apt was not found in the working directory or in $APT_ORCHHOME/etc. ##F TFCF 000009 Fatal Error: Cannot continue without a configuration file. I thin...

Smartie Mike!!!!!

I was asking if I need to use Convert function.
If I need to use that, I need to specify all the list of non numeric character in the list. Which I don't want to.

What is the efficient way to remove Non Numeric for a field. Eg: I need to remove the non numeric character in the Field "No" Input ----- ID | No 1|003A23 2|234-456 3| 2333 Output -------- ID | No 1|323 2|234456 3|2333 I dont think I need to specify all the non numeric character in the Con...

How can I assign Col1, Col2 on the fly? If the number of columns changes everytime of the run?

Hi, May I know the configuration that we need to do for connecting a MS SQl server from a Unix Datastage Server. We have the odbc.ini updated as follows. WHRPOSDEV=MS SQL [DBNAME] Driver=/opt/nz/lib/lib/libtdsodbc.so Description=MS SQL ODBC Servername=SERVERNAME Port=1433 Database=DBNAME ReadOnly=fa...

This requires, finding the maximum column and then strandadizing the layout then Pivot stage.
But there should be a option with some of the restructure stage.

Hi,
How can I acheive the output from the given input.
What is the best "Restructure" stage that can be used to achieve this?