View previous topic :: View next topic |
Author |
Message |
tomehta Beginner

Joined: 19 Dec 2003 Posts: 17 Topics: 5
|
Posted: Fri Jun 11, 2004 2:18 am Post subject: comp values select in sql query |
|
|
Hi
I have a doubt, there is a varchar in a table which is having some computational values along with the other values, some kind of greek is visible in that column . I want to see the actual values of those in SQL query itself, without using a cobol program.In the varchar we are moving some computional values and some characters. I am able to see the characters but not the computational values. How i can see both in the sql query? I do'nt want to use cobol program. |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
|
Back to top |
|
 |
psridhar Beginner
Joined: 16 May 2004 Posts: 68 Topics: 26
|
Posted: Wed Jun 23, 2004 2:16 pm Post subject: |
|
|
Hi Kolusu,
I could not get your reply. Let me extend how I understand the question. I have a column of varchar(300) in a table T1 in which I store the DCLGEN of a row from another table T2. The varchar column looks as follows.
<DE0006288921... |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Wed Jun 23, 2004 2:48 pm Post subject: |
|
|
PSridhar,
You cannot see the data in Spufi. If you have QMF then you can view the data.
Log on to QMF
Press PF6
Type in your Select Query
Ex:
Code: |
SELECT VARCHAR_COLUMN
FROM TABLE
|
Press PF2 to execuete the Query
now you will be presented with the results from your query
Press PF9
Now will see a FORM with NUM, COLUMN HEADING, USAGE, INDENT, WIDTH, EDIT and SEQ
Under the EDIT column it is defaulted to C . Now over type XW under the EDIT column and Press Enter
Now Press PF12
Now you can see the contents of the varchar column
Hope this helps...
cheers
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
 |
CZerfas Intermediate
Joined: 31 Jan 2003 Posts: 211 Topics: 8
|
Posted: Thu Jun 24, 2004 6:12 am Post subject: |
|
|
What you can do is get a glimpse of the content of this dubious varchar column via the HEX function in the SELECT clause of your statement. Using that one you can look at the hex values of the column content.
By the way, it is always advisable to store information atomic, that is: one value in one column. Than you are able to use the proper data type definitions.
regards
Christian |
|
Back to top |
|
 |
|
|