regarding target file creation
Moderators: chulett, rschirm, roy
regarding target file creation
Hi All,
My target is ODBC and i have checked the option create target table but while runnig the job it is showing that target table cant b created.Please let me know the reason.
Regards,
RAGHU
My target is ODBC and i have checked the option create target table but while runnig the job it is showing that target table cant b created.Please let me know the reason.
Regards,
RAGHU
please help me
Hi all,
Please help me in doing this it is very urgent
Please help me in doing this it is very urgent
-
- Participant
- Posts: 30
- Joined: Mon May 29, 2006 11:19 pm
Re: please help me
Just check whether the same table is not existing in u r database or else put the table name in uppercase
Hameed
Hameed
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
Re: regarding target file creation
maybe, just maybe....vijaya wrote:Hi All,
My target is ODBC and i have checked the option create target table but while runnig the job it is showing that target table cant b created.Please let me know the reason.
Regards,
RAGHU
Code: Select all
Tables can neither be created nor be destroyed but can be converted from one form into another
most of the times, the log message+google will do the trick for db related errors.
Re: regarding target file creation
That is not completely correct. One can create table from within the ODBC stage and create/drop tables from the DB stages. Make sure that you are using generated sql and not user-defined sql. If you are still not able to, then post the error messages.prabu wrote:
maybe, just maybe....Code: Select all
Tables can neither be created nor be destroyed but can be converted from one form into another
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
good to see a serious response on thisDSguru2B wrote:Kris, i think prabu was just kidding as he was re-iterating newtons third law of physics.
the world of missing smiles
Code: Select all
Every person in a state of uniform [rational] mind tends to remain in that state of mind unless an external [b]nut case[/b] triggers him
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What is the reason that you can not create the table? What error code appears in the error/warning in the job log? For example, do you have appropriate permission in the database to create tables? Did the DROP TABLE statement fail (which would cause a CREATE TABLE statement to fail)?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 17
- Joined: Tue Apr 11, 2006 2:35 pm
Re: regarding target file creation
Guess the UserName you are using to connect to the ODBC target does not have enough privileges to create tables in the db schema.vijaya wrote:Hi All,
My target is ODBC and i have checked the option create target table but while runnig the job it is showing that target table cant b created.Please let me know the reason.
Regards,
RAGHU
Check db privileges for this user
Deepak