RE: problem with SQL query manager

Dale, maybe you want to cast your result ?
Here is an example that I had on hand:

CAST (
CAST (REPLACE(cshcol,' ','0')
AS NUMERIC(10,0))/100
AS NUMERIC(10,2)) AS cshcol92

NUMERIC is the Sql equivalent of zoned,
DECIMAL is the Sql equivalent of packed
HTH

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Dale Janus
Sent: Wednesday, March 19, 2014 9:19 AM
To: RPG
Subject: problem with SQL query manager

I was using query manager to create a quick inventory cost report for selected vendors. Our material is stored in feet and inches and a cost per foot. I divided inches by 12, added to feet and multiplied by cost per foot. This was a created expression using the prompts in query manager
The result field was 32 positions long. While I could read the detail data, the total line was too long to display. (maybe it would have printed, I did not try).

So I tried rounding the expression and truncating the expression. Result was the same.

Can anyone tell me how to define the length of an expression in query manager?


Here are some screen shots.


Define Expressions

Type expression using field names, constants, and operators, press Enter.
For full name and expression, press F4.
Valid operators are: +, -, *, /, CONCAT ...

Name Expression
COST2 ROUND(COSTFT+COSTIN,2)
COST TRUNCATE(LENGTH*INCOST,2)

More...


Edit Column Formatting

Type information, press Enter.
For Usage and Edit, press F4 for list.
For Heading, press F4 for prompt.

Column Heading Usage Edit Seq Indent
Width
INVEN# VENDOR_NUMBER 1 2 7
INODM OD 2 2 6
INWALL WALL 3 2 5
COST COST 4 2 33
INFT LENGTH_FEET 5 2 6
ININ LENGTH_INCHES 6 2 6
LENGTH LENGTH 7 2 33
INCOST COST/_FOOT 8 2 9


Display Report
Query . . . . .: * Width . . .: 142
Form . . . . .: * Column . .: 1
Control . . . .
Line
....+....1....+....2....+....3....+....4....+....5....+....6....+....7.
VENDOR LENGTH
LENGTH C
NUMBER OD WALL COST FEET INCHES LENGTH F
------- ------ ----- ---------- ------ ------ ----------
-----
000001 194613 3.500 .438 ?????????? 6
********** 11
000002 194613 3.500 .438 ?????????? 1 6
********** 11
000003 194613 3.500 .438 ?????????? 1 7
********** 11
000004 194613 3.500 .438 ?????????? 22 8
********** 11
000005 194613 3.500 .438 ?????????? 35 5
********** 11
000006 194613 3.500 .438 ?????????? 35 6
********** 11
000007 194613 3.500 .438 ?????????? 35 6
********** 11
000008 194613 3.500 .438 ?????????? 35 6
********** 11
000009 194613 3.500 .438 ?????????? 35 7
********** 11
000010 194613 3.500 .438 ?????????? 35 7
********** 11
000011 194613 3.500 .438 ?????????? 35 7
********** 11
000012 194613 3.500 .438 ?????????? 35 7
********** 11
000013 194613 3.500 .438 ?????????? 35 7
********** 11
More...