synthetic key

[#1]

hi

can we use qualify keyword when trying to avoid synthetic key situation in the files loaded from oracle data source.

if yes please explain with an example?

[jagan]

Hi,

You can also avoid Synthetic key using the Qualify statement.

Example:

LOAD

A,

B,

C

FROM Table1;

LOAD

A,

B,

D

FROM Table2;

Qualify B;

In this way you can avoid the Synthetic key.

Regards,

Jagan.

[#3]

SQL SELECT
ENAME &
SALARY AS KEY ,
    ENUM,
    MRGNAME
   FROM SCOTT.EMP123;
  
SQL SELECT
    ENAME&
     SALARY AS KEY  ,
    ENO,
    DEPT
FROM SCOTT.EMPLOYEE;

this is my situation. tell me how to work on it?

[jagan]

Hi,

You won't get Synthetic key for this because you have only one column in column i.e., KEY

Table1:

SQL SELECT

ENAME &

SALARY AS KEY ,

    ENUM,

    MRGNAME

   FROM SCOTT.EMP123;

Table2:

SQL SELECT

    ENAME&

     SALARY AS KEY  ,

    ENO,

    DEPT

FROM SCOTT.EMPLOYEE;

Use the above script without Load.

Hope this helps you.

Regards,

Jagan.

[#5]

its not working that is the problem i am facing right now.

[CELAMBARASAN]

Hi,

     I think you should use +(Plus) instead of ampersand(&)    

Table1:

SQL SELECT

ENAME +

SALARY AS KEY ,

    ENUM,

    MRGNAME

   FROM SCOTT.EMP123;

Table2:

SQL SELECT

    ENAME+

     SALARY AS KEY  ,

    ENO,

    DEPT

FROM SCOTT.EMPLOYEE;

Celambarasan

[#7]

still its not working with the use of + sign.

the error i am getting is

SQL##f - SqlState: 22005, ErrorCode: 1722, ErrorMsg: [Oracle][ODBC][Ora]ORA-01722: invalid number

SQL SELECT
    ENAME +
     SALARY as key   ,
    ENO,
    DEPT
FROM SCOTT.EMPLOYEE

help me please

[jagan]

Hi,

I think you are using Oracle then

Table1:

SQL SELECT

ENAME || SALARY AS KEY ,

    ENUM,

    MRGNAME

   FROM SCOTT.EMP123;

Table2:

SQL SELECT

    ENAME || SALARY AS KEY  ,

    ENO,

    DEPT

FROM SCOTT.EMPLOYEE;

Regards,

Jagan.

[CELAMBARASAN · Accepted solution]

Hi,

     Oh sorry,

     In oracle it is || (Concat symbol or pipe symbol) which is above the enter key.

Celambarasan

[#10]

thnx for your help...its working.

but in my case i am concatenating name and salary. the resultant list box is showing fieldvalues like this

ram345657

jai657289

can we use qualify keyword in it ??

if yes please help