JeffNolan1900
Technical User
Hello,
I have a database populated with about 500 tables, all of which are blank (as far as data goes). The tables are linked properly, have fields (ADDRESS_ID for example), and are set up, but completly empty of data. The database is auto-created thru a filter process using another application and so every time I re-run the filter I will have to go into the database and add a dummy record into each table, which will be quite tedious.
The reason I need a dummy value in each table is because I am trying to map the Access Database info using FME Workbench to an Oracle 10g Database. The problem is that FME will not translate Access tables to Oracle when they are blank. Does anyone know of a coding method to auto-add dummy records to the first column in all tables.
I want to end up with this.
Table1:
ADDRESS_ID USER_NAME
1
Table2
LOCATION_ID ROOM_NAME
1
Basically, I want to add the value 1 into the first column of each table, despite the table name, or column name.
[small]note: any table that starts with d_ has to be ignored, since they are already populated. This is not a big deal and I can add a if d_ then else statement.[/small]
Thanks so much for your time in advance.
Jeff
I have a database populated with about 500 tables, all of which are blank (as far as data goes). The tables are linked properly, have fields (ADDRESS_ID for example), and are set up, but completly empty of data. The database is auto-created thru a filter process using another application and so every time I re-run the filter I will have to go into the database and add a dummy record into each table, which will be quite tedious.
The reason I need a dummy value in each table is because I am trying to map the Access Database info using FME Workbench to an Oracle 10g Database. The problem is that FME will not translate Access tables to Oracle when they are blank. Does anyone know of a coding method to auto-add dummy records to the first column in all tables.
I want to end up with this.
Table1:
ADDRESS_ID USER_NAME
1
Table2
LOCATION_ID ROOM_NAME
1
Basically, I want to add the value 1 into the first column of each table, despite the table name, or column name.
[small]note: any table that starts with d_ has to be ignored, since they are already populated. This is not a big deal and I can add a if d_ then else statement.[/small]
Thanks so much for your time in advance.
Jeff