DSXchange

this is my flat file which i want to read Branch,Acct_No,Invoiced_No,Reg_No,Invoiced_Desc,Total Rent ADFIX,AGN01,12010,RFGA001,Car Rental daxion,12010.5012 ADFXL,AGN01,12011,RFGA002,Car suveria anixum,14012.4512 ADFVL,AGN02,12012,RFGA003,Car various pack,24000.2345 ADFIX,AGN02,12013,RFGA004,car mazi...

can i use odbc stages as a look up or i need to convert them to hash files.

hi all i have a source table containing fields like id,name,location,country_id,region_id.there are also two other tables with only two columns.lets say country_table with country_id and country_name .another one region table with region_id and region_name. i want to have a look up both for country_...

hi all
can you please tell me the code how to find lastday of previous month in dd-mm-yyyy format

i am new to this forum.
i am not able to read the whole post.a part of the post is getting truncated.
why is it so...........

thank you for your response.
can you plz tell me in the table defination why a data element column and display column is there.what are the significance of those columns

hi all this is rather a more theoritical question than a practical one.when we import table defination as ODBC we specify the DSN,user name,password and table name.so the column defination is imported and stored in the repository.but there is an option to create the table in the database from DataSt...

hi all
i need to update my table with last update date and datawarehouse load date.how can i achieve this functionality with time stamp.plz suggest me the functions :D

hi all
is there any initcap function in DataStage.How can i do initcap in DataStage..

got your point..
i made a mistake in my job..so error was coming..now it running fine..
thanks for your response

hi all i am reading a column in the flat file as string i.e varchar.while loading it into the oracle table the column defination in the table is number.so i am unable to load the column.i am using ODBC stage for this purpose.can anybody suggest me how can i convert varchar to number to load into tab...

yes i got the solution

yes the error it is showing here is
Failed to connect to host: localhost, project: UV
(User name and/or password incorrect (80011))

hi all in our company we have installed datastage server version on a windowsXP machine in one of our PCs.and all the client versions on Windows XP.We have created a project called Main_Project for training purpose.but while logging into the project we have to specify the host system user id and pas...

ok thanks