Clarifications

Tools & Utilities
Enthusiast

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..&TARGETTABLE

does it mean like in oracle from first ...to last
or the tablename??

Rgds,
Raja
1 REPLY
Enthusiast

Re: Clarifications

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.

So

TABLES &DBASE_TARGETTABLE..&TARGETTABLE

becomes

TABLES fexp_usr.i999839999

Your 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.