DSXchange

hi gourab,

try this out...

TimestampToDateTime("your date field",StringToTime("00:00:00"))

The one which are in Bold are the datastage functions.

Hi All, Thanks for all of u for giving me useful suggestions...my issue is resolved... Have you tried just SELECT SCHEMA.TABLE1.FIELD1 ABC..... What is your job desing. If you have any transformer or modify or any other stage which aids renaming the column, you can do it before joining ... this is t...

Have you tried just SELECT SCHEMA.TABLE1.FIELD1 ABC.....

i also tried that...but

if you specify a valid alias in the SQL, that will be passed to DB2/390 and honoured.

please specify the syntax for aliasing...

Thanks

the tables are in the source... I am joining two tables both of which have a field with the same name (with different values of course) and that field is NOT my joining key. but i need both fields in my output. the problem is not in extraction but in writing the query. I have to alias the field so t...

Hi all,

I am developing a job using Mainframe tables, where i am getting a conflict between two fields in different tables with the same name which i need as output.

so, can some one please suggest me the syntax for aliasing in MF job.


Thanks