DsRoutines
Posted: Sat Jan 19, 2008 12:43 am
I am writing a routine as follows. It selects data from Hash File.
-----------------------------------------------------------
$IFNDEF JOBCONTROL.H
$INCLUDE DSINCLUDE JOBCONTROL.H
$ENDIF
LenJobName='30L'
Command = "SELECT CIRCLE FROM GEO "
Command := " WHERE CODE= ": Code :" ;"
Call DSExecute("UV",Command,Output,Code)
Ans=Output
@USER1 = Ans
MainExit:
Return(Ans)
-------------------------------------------------------------
The out I am getting as follows.
==================================
TEST #1
*******
Arg1 = 9324
Test completed.
Result = CIRCLE
MU
1 records listed.
==================================
I need to get only the value of the column,that is I need only MU .
I dont need column heading CIRCLE_CD and 1 records listed. The actual result is MU only.How to frame the query to avoid column headings.
-----------------------------------------------------------
$IFNDEF JOBCONTROL.H
$INCLUDE DSINCLUDE JOBCONTROL.H
$ENDIF
LenJobName='30L'
Command = "SELECT CIRCLE FROM GEO "
Command := " WHERE CODE= ": Code :" ;"
Call DSExecute("UV",Command,Output,Code)
Ans=Output
@USER1 = Ans
MainExit:
Return(Ans)
-------------------------------------------------------------
The out I am getting as follows.
==================================
TEST #1
*******
Arg1 = 9324
Test completed.
Result = CIRCLE
MU
1 records listed.
==================================
I need to get only the value of the column,that is I need only MU .
I dont need column heading CIRCLE_CD and 1 records listed. The actual result is MU only.How to frame the query to avoid column headings.