DSXchange

Hi all, i am trying to upload text file to as400/db2 table through ODBC stage. it doesn't upload the data and give this warning log: "***BCIPut call to SQLExecute failed **** [DataStage][SQL Client][ODBC][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - Table2 in FahadLib not valid for operat...

imagin.. i restarted windows and it worked...
welcome to the World of Windows...

thanks guys

the path is there.. and the user is administrator.

if you mean the Windows system path, yes oracle path is included.

Hi all, i have jobs running fine, i moved these jobs to new server (windows 2000) and when trying to get data from oracle 8 it gives this error: "ds_loadlibrary:Win32 error in LoadLibrary of oraoci8.dll - The specified module could not be found" i removed oracle client and installed it aga...

Hi all, i am trying to connect to oracle 9i on unix from my pc through datastage but couldn't. when i want to import table definitions i got this message "DSR.MetaGeta(GET.TABLES)(SQLConnect('RDBPROD','rdb')): BCI Error: SQLSTATE=IM004,CODE=0,[DataStage][SQL Client][ODBC][Microsoft][ODBC Driver...

Hi all, i want to move arabic data from text file to Unix-Oracle database. oracle character set is AR8ISO8859P6 (to have arabic data) but there is no NLS set like that in Datastage. i tried with many NLS setting on the Oracle stage of the job but either give error or deliver data as garbage (questio...

yes it worked.. the user name and password under the schedule tab was empty..

thanks sainath

Hi all, i have a job getting data from AS400/db2 to Oracle.. when i run the job myself data goes perfectly. but when i schedule the job even after 5 minutes it give me error of "call to SQLConnect failed" ... the connect to the db2 is through ODBC and i tried it to be without SQL prompting...

Hi all, am kind of beginner in DS and i have to write jobs that take data from AS400/db2 to Oracle on a daily basis.. the data to be pulled is that with today's date. i tried to make a parameter variable in the select statement but this will have a manual entry. is there any way to make it auto?? no...

thank you for the reply.. however, the source table is not sorted in asc or desc base order. my main problem is the duplicates in the source table and using hash file stage i can remove the duplicates by keeping the last record while i need the first one.. so i thought of reversing the records order...

dear all,
i have set of records and i want to reverse them.. for example,

01 John IBM
02 George MSN
03 Peter Oracle

required to be

03 Peter Oracle
02 George MSN
01 John IBM

is that possible in DataStage???
thank you all and i will appreciate any reply

thank you very much guys,
i used a hash file in the middle and it removed the duplicate rows

thanks again for quick help. :D :D :D

hi all,
i have a data source of text file and a target of two flat files,
i need to set a uniqueness check for two columns to avoid duplicates.
how can i do that?? is there any routine to do that??

thank you all

Hi all,
is there a way to use the DataStage as an archival tool.??
i believe there should be some ways but couldn't find any..

thank you in advance..