Generic Load Problem!!!

[Anonymous]

Hi guys ,

I have a data stored on Sql server 2014 contains one table called Complex Type.

what i want to do is generate a generic prefix fro Complex Type table.

Firstly i made a connection to data base by writing this statement :

LIB CONNECT TO 'DEV1-PC-MSSQLSERVER2014 (desktop-dpummb2_yaman)';

after that i want to generate generic prefix using this statement :

Generic LOAD

       ParentID,Name,ID From ????

swuehl‌

stalwar1‌diego.a.barboza‌hic‌

what  should i write after ''From'' keyword to reach Complex Type table.

Please can you help me.

[swuehl · Accepted solution]

You need to use a SELECT statement when reading from your SQL database:

Generic

SELECT

       ParentID,Name,ID

FROM YourTableName;

[shraddha_g]

TableName will be there.

But makesure you use correct databasename before table Name.

[Anonymous]

Thanks it is solved.