Thanks, jimm, for your replay. I guess i described the situation not clearly.
I have to make some procedure, programm or use functionallity of some tool to make inserts on any table in Teradata. Usually, RDBMS have management tools with such functionallity. I used PL/SQL Developer to make such inserts in Oracle (ofcourse it is 3d party tool, but it is free for use).
But I haven't found such functionality in Teradata tools. I started to make procedure, wich would make inserts on any table.. it uses 2 parameters: database name, table name, and works with DBC.Columns to know the structure of the table. But my knowledge of Teradata is poor.. in Oracle I would make it much faster.
Hi, I am not too sure if I understood your question correctly. But one solution IF YOU ARE USING DYNAMIC inputs for Inserts in Query Assistant is:
INSERT INTO TAB A ( COL1, COL2, COL3) SELECT (?,?,?);
When you run this query, it will prompt you to enter the values for each column dynamically. If it does not prompt you individually, it will expect a filename which means you have opted for File Import mode which is the wrong mode for single inserts. If this is not what you were looking for, get in touch.