You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » tcreatetable for DB2 adds extra quotes
#1 2012-06-08 15:36:17
- syedasiftanveer
- Member
- Registered: 2012-01-16
- Posts: 72
tcreatetable for DB2 adds extra quotes
Tags: [db2, tcreatetable]
Hi,
I am creating DB2 tables using tcreatetable and it appears so that talend adds additional quotes to the table.
Like if I enter "Branch" in the table field then the table actually created will be "Branch" rather than Branch.
Please tell me how i can make it right.
Regards
Asif
Offline
#2 2012-06-11 06:51:15
- syedasiftanveer
- Member
- Registered: 2012-01-16
- Posts: 72
Re: tcreatetable for DB2 adds extra quotes
Any ideas?
Offline
#3 2012-06-11 07:18:12
- syedasiftanveer
- Member
- Registered: 2012-01-16
- Posts: 72
Re: tcreatetable for DB2 adds extra quotes
Okay i got the answer but its not the solution.
while creating tables with tcreatetable in DB2, talend will add extra quotes ("") to the table names and columns if they are in lower case like branch.
If I change it to BRANCH (upper case) than no extra quotes will be added.
Regards,
Asif
Offline
#5 2012-06-11 08:10:32
- syedasiftanveer
- Member
- Registered: 2012-01-16
- Posts: 72
Re: tcreatetable for DB2 adds extra quotes
TOS DI 5.1.1.r84309
Regards
Asif
Offline
#6 2012-06-11 08:26:10
- pedro
- Member
- Registered: 2011-11-17
- Posts: 3682
Re: tcreatetable for DB2 adds extra quotes
Hi Asif
Please report it on BugTracker.
Regards,
Pedro
Only Paranoid Survive.
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » tcreatetable for DB2 adds extra quotes