Hi,
we are trying to load a cobol file into a oracle table (with 600 columns in table).we just Insert rows into the table.
We use the write Method Upsert and then select the Upsert mode as 'User defined update only',and write the Insert statement in there.But since table has many columns the whole insert
statement does not fit in the space assigned.
Any idea how to over come this issue.
I am unable to use the Write Method as Load as we do not have the sql loader set up.
Thanks
Oracle Enterprise stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
keshav0307 - that might take up needless storage; I think we get the picture. But I would like to know which limit you have reached - that of the DS-Window or some Oracle limit? How long is your SQL?
rajkraj - can you see things to strip away in your SQL? shorter column names? schema.table.column type references which might work with just "column"? Long colum names you can alias?
rajkraj - can you see things to strip away in your SQL? shorter column names? schema.table.column type references which might work with just "column"? Long colum names you can alias?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
when i save the sql in notepad the size is 33 kB.
Thanks Arnd, I just have the column names,not in the form of schema.table.column.
Is there any other way than changing the column names .
when we insert values into columns as ORCHESTRATE.<column value> in the Insert statement that is taking some space.(But i guess we cannot avoid it.)
Thanks
Thanks Arnd, I just have the column names,not in the form of schema.table.column.
Is there any other way than changing the column names .
when we insert values into columns as ORCHESTRATE.<column value> in the Insert statement that is taking some space.(But i guess we cannot avoid it.)
Thanks
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia