DSXchange

Hi Ray

Thanks for the reply ,The UniChar function is not available in PX, how to handle this with out using Basic Transformer ?

ray.wurlod wrote:

Code: Select all

UniChar(2601)

I've Installed Datastage 7.5 ea2 on Windows Platform. Iam able to access all stages and develop jobs. However am unable to view data or run them.

Is it that jobs can be developed on windows enviroment using 'ea2' version and can be executed in Unix environment?

Regards,
Sam

Could some one let me know how different is 'ea2' version from the Enterprise version.

Can the run time version of Datastage ea2 be installed on Windows Platform? Are there any pre requisties if we can do so?

Thanks in Advance,
Sam

Hi all, I have a scenario, where I have a table with one of those columns, which gives me the 'SQL ( select stagement which is expected to return four columns ) stament'. Is there a way I can assign this string ( SQL statement ) value to some variable and then use the same in an ODBC stage ( In the ...

A search of the forum will reveal that the DB2 stage expects DataStage internal format. Try @TIME by itself. Otherwise, use the current time constant in DB2 SQL. I forgot to mention that am using ODBC stage instead of DB2 stage. The datastage internal '@time' function wouldnt work. Could you brief ...

Is there a function in datastage that returns the datype (sqltype) of a field value as interpreted by the source during extraction?

Cheers,
Shyam

Hi all, I have an issue loading Time into a DB2 table field ( sql type 'Time' length 8 ). When i use Oconv(@time, "MTS") , the database wouldnt accept the return value identifing it as a string. To my utter surprise,The same derivation Oconv(@time, "MTS") for a Timestamp field ( ...

Hi guys, Am trying to create an ODBC connection to talk to a DB@ database. I modified the .odbc.ini file with the database name, package name, portnumber. Even the uvodbc.config was taken care of. When i try to import a source defination using the odbc in the designer. After having selected the resp...