resident load

[#1]

      hiiii,

i have a data loaded from inline .

i want to jst ask is it possible to generate table using resident load from data which is loaded inline

[#2]

yes it is possible.

table1:

load * inline

[

col1,col2

a,20

b,50

];

noconcatenate

table2:

load *

resident

table1;

[tresB]

Yes. Like below:

Tab1:

Load * Inline

[ Field1, Field2

     A, 10

     B, 20

];

Tab2:

Load *, '1' as Dummy Resident Tab1;

[rajat2392]

Hi Akash,

Yes it is absolutely possible. You just have to give a table name to the inline table you are creating. As you can see below

Table1:

Load * Inline

[

Column1, Column2

......., ......

......., .....

];

NoConcatenate

New_Table:

Load *

Resident Table1;

Drop Table Table1;

This is how you can resident load from a inline table.

[#5]

@Rajat, your code won't work. This will simply concatenate the second load statement into the first table. It will never create the 'New_table' as the structure of this is similar to the existing table. You have to have a noconcatenate before the second load.

Thanks,

Ram

[rajat2392]

Hi Ram,

Thanx for the correction, I forgot to write it.