DSXchange

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.

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.

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

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?