23 Jul 2009
The .SET sets a multiload variable.These are referenced by prefixing the variable name by &; if you want a period in the output then you code two periods.SoTABLES &DBASE_TARGETTABLE..&TARGETTABLEbecomesTABLES fexp_usr.i999839999Your DML statements will use the same construct for the database/ table.So if you want to load a completely different table, you only have to make the change once - as long as it is identical structure.
You must sign in to leave a comment.
Hi,Can someone explain to me this code: .SET DBASE_TARGETTABLE TO 'fexp_usr'; /*This I underwstand */.SET TARGETTABLE TO i999839999;/*This I underwstand */.BEGIN IMPORT MLOAD /*This I underwstand *//*This I DONT underwstand */TABLES &DBASE_TARGETTABLE..&TARGETTABLEdoes it mean like in oracle from first ...to lastor the tablename??Rgds,Raja
Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.