Auto-generate SQL in a Connector stage

srinath0253 · Post by **srinath0253** » Sun Apr 17, 2016 9:22 pm

Hi,

I searched in DSXchange posts and didn't find matching posts, so I'm writing new topic.

I designed an job in DataStage 8.7. This job has sequential file -> transformer -> Oracle connector. While loading to target stage I'm able to write user defined SQL or SQL built thru the SQL builder option. I feel that the SQL Builder is not handy.

I like old style auto generated SQL method based on columns. In the enterprise stage there is an option to auto generate SQL. Do we get similar kind of stuff in connector stage? In one click we would get insert/update statements based on columns.

Thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Sun Apr 17, 2016 11:35 pm

Yes there is, and yes you do. The very first property on the link (Usage grid) in a Connector stage type is Generate SQL, and it takes Yes or No as its value.

If you set it to Yes you must provide the Table Name (of course).
If you set it to No you must provide an SQL statement.

chulett · Post by **chulett** » Mon Apr 18, 2016 6:17 am

Yeah, never was a fan of any kind of 'SQL Builder' option.

srinath0253 · Post by **srinath0253** » Fri Apr 29, 2016 7:45 am

Sorry for late reply.

Ray, im not premium user to see your post.
I gone through all the tabs and options in connector stage but couldn't find any. Are you talking about grid in sql builder?