Hi

[#1]

Hi, i have creates Table like Table1:select A,b,c from tblfinanc so i want to pull the column A from Table1. i tried select A from Table1 ; but it didn't worked. So how to pull the column from Table1?

[manojkvrajan]

SQL statement will not work after you extract the data from your database. Please check if it works.

// Assume Table1 is from your Relational database - Oracle / Mainframe

Table1:

SELECT A,B,C

FROM tblfinanc;

// Assume Table2 is the Resident table that you can use to transform the data

Table2:

LOAD A,

1 as %key

RESIDENT Table1;

DROP TABLE  Table1;  // Drop Table if it won't be useful.

DROP FIELD %key;

[MayilVahanan]

Hi

     Do you want the A only from table1;

     Then why you load all from sql.. Select A from tableName itself enough.. Can you say clearly what your requirement?