DSXchange

Can I directly put SQL query in Execute command?.The query that i want to run is as follows.

ALTER TABLE SCHEMA_NAME.TABLE_NAME DROP PRIMARY KEY.

Where exactly do i need to put this stage so that it executes only once.

Thanks
in advance

Hi All, I am loading the data from difference schema using Sequence and in this i am using Startloop,Activity and Endloop to change schema names at run time.....the main thing is that i am droping the index of the target table before loading and creating after load for that i am using open and close...

Thanks Sud its working perfectly fine..... :D

its not working where exactly i have to use $counter because its already picking the schema names with startloop.$counter.

I am using env. variable to pick the schema name and in the sequence i am using activity stage to pick all the values of schema with this i am using startloop and endloop to loop it everytime.....

Can't we pick some default value in variable and increment it every time when ever schema gets change in Sequence?

Hi, I have 23 schemas and one target in that target we have one extra column which is not present in the source tables so we have to hard code the different values for different schema. e.g it should be like that for 1st schema it should be 1....2nd to 2....3rd to 3 and so on.....and i am using SEQU...

Hi All,


I am also getting same error while importing the tables...if any one have got the solution...plz let me know...


Thanks in advance

Sumit

Thanks a lot. Its working fine...

Hi All, I have a scenario, I am using DB2 as source and target and I have 23 schema and in all the 23 schema all the table having same structure and column names and i have to load all the records to the target from all the 23 schema, Can we change the schema name at runtime? Thanks in advance... Su...

Hello Everyone, I am getting error when loading data in a Db2 table using DB2 UDB enterprise stage. I am using write method as Load and partitation method as Same and getting following error. DB2_UDB_Enterprise_1,0: DB2 Load Binary Error. DB2_UDB_Enterprise_1,0: SQLCODE = -27959; SQLSTATE= /dstage/A...

Ya that's the property of ODBC stage but this is for sever job's and here i m using parallel job...and this job doesn't have any property like that....

Thanks for the reply, Do we have any property in ODBC Stage by which i can set commit after some intervel of records.

Hi All,

I am getting problem of Transaction log full. My Database is Db2 and i am trying to load 10 million records using ODBC Drivers Stage. Please let us know how to overcome this

Hi This is the first installation and there were no errors during the setup. As its a fresh installation so never before i was able to view the data. To explain the scenario. When i try to import the table definition using import meta deta definitions when i click on the Db2 it gives the error of &q...