DSXchange

Hi guys, I am trying to convert data in xml into cvs file. job i have design is source_file > Xml_input > sequential _file I have designed the job as mentions in this link which is provided in dsxchange http://it.toolbox.com/wiki/index.php/Load_XML_files_using_a_DataStage_Parallel_job but when i am ...

Sorry to distrub you ray !!!!!! thanks for your suggestion

Please any one help guide me out

Here is the error i got from systemout.txt file [1/21/10 10:30:33:547 EST] 0000000a NameServerImp A NMSV0018I: Name server available on bootstrap port 2809. [1/21/10 10:30:33:969 EST] 0000000a UserRegistryI A SECJ0136I: Custom Registry:com.ascential.acs.security.directory.custom.websphere.ASBUserReg...

Here is the error i got from systemout.txt file [1/21/10 10:30:33:547 EST] 0000000a NameServerImp A NMSV0018I: Name server available on bootstrap port 2809. [1/21/10 10:30:33:969 EST] 0000000a UserRegistryI A SECJ0136I: Custom Registry:com.ascential.acs.security.directory.custom.websphere.ASBUserReg...

Thanks for your replay ArndW. So the best to start the running the server is re-install the software again. Actually i am using direct acesses to the server i am not using the client to connect to server since we are doing only simple test process...actually work will be working on unix enivronment....

here is error getting when i am trying to start the server. ************ Start Display Current Environment ************ Host Operating System is Windows 2003, version 5.2 Java version = J2RE 1.4.2 IBM Windows 32 build cn142-20080130 (SR10) (JIT enabled: jitc), Java Compiler = jitc, Java VM name = Cl...

Hi, Actually i am infoserver 8.1. I have installed it properly, but unfortunatly i have uninstalled the .netframe work which get installed along with the installation of infoserver. so i have downloaded the 1.1.net frame work and installed it. But when i am trying to login it is not allowing me logi...

actually i tried with both of them user define and as well as auto generated sql but i am getting the same error as you mention then i have restart the system and created the new job and selected auto generated job. then it is working fine, after that then i check with user define sql it is not work...

Thank you very much for your help ray and chulett actually when i try to run the job with auto generated sql records are loading into db2 database but when i am trying to create user define sql it is not loading. Atleast i am able to load the data. Still i am little bit confused why it is not workin...

Hey chulett i have replace the db2 udb stage with new one and run the job but i am getting same error

APT_CombinedOperatorController,0: Fatal Error: Fatal: This SQL statement did not contain the same number of parameters as columns on this link. This usually happens with user-defined SQL

Using ODBC stage i am able to insert the data into DB2 remote database but not able to insert with db2 udb stage. do i need to set any additional environment variables

ok chulett i wont use user define sql but how to run the job. I am unable to understand what exact problem is able to view the data for auto generated sql but unable to run the job. when i actually the db2 database which i am loading is remote database and it is on main frames. I have catalog the da...

Hi i have try to insert the record using user-define sql but when i am trying to run the job. Job is getting aborted and displaying error stating that [0001]DB2_UDB_Test_Job2..DB2_UDB_API_2: [IBM][CLI Driver][DB2] SQL0206N "ORCHESTRATE.CONTACT_TYPE_CD" is not valid in the context where it ...

thank for your suggestion ray. I had Checked it even though i am using generated sql it is taking user define sql. so now do i need to re-create the job or remove the db2 udb stage and replace it again.