All Forums Tools
Raja_KT 1246 posts Joined 07/09
20 Jul 2009
Clarifications

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.

Jimm 298 posts Joined 09/07
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.