Hi! I am trying to query an oracle DB using SQL in webfocus. Once I do a table hold and review my hold file. I am seeing a field value description prior to every fields. I tried using format alpha but it didn't help. Thanks in advance.

e.g. hold file

Firstname for 5 bytes field, Lastname for 5 bytes field

003Joe 005Smith

ENGINE SQLORA SET DEFAULT_CONNECTION TEST
SQL SQLORA PREPARE SQLOUT FOR
SELECT LAST_NAME,FIRST_NAME;
END

TABLE FILE SQLOUT
PRINT LAST_NAME FIRST_NAME
ON TABLE HOLD AS TEST1 FORMAT ALPHA
END

-RUN

quote:

PRINT LAST_NAME FIRST_NAME

You appear to be getting 'column headings' try
PRINT LAST_NAME AS '' FIRST_NAME AS '',
NOTE NO SPACE BETWEEN SINGLE QUOTE MARKS.

I just tried it. It didn't work. Thanks.

quote:

Firstname for 5 bytes field, Lastname for 5 bytes field

You mean "Firstname for 3 bytes field, Lastname for 5 bytes field".

How are the columns defined in the Oracle table?

Actual Oracle Fields:

SPRIDEN_ID VARCHAR2(9 BYTE) NOT NULL,
SPRIDEN_LAST_NAME VARCHAR2(60 BYTE) NOT NULL,
SPRIDEN_FIRST_NAME VARCHAR2(15 BYTE)

Actual Output:

000009A00000999 534390000005AAAAA 00006AAAAAA

I replaced the first and last with AA's. Thanks.

Add this to your procedure (or global profile)

SQL SQLORA SET VARCHAR OFF

N.Selph, Thank you so much! It worked.