Null???

N

nexxus

New Member
1st time working with Progress!
Im pulling data using DecisionStream by Cognos. I need NULL fields to have 'NONE'.
When i'm trying to execute IFNULL (To_Char (cc_ctg), 'NONE'....... it's not working.

Please explain what should i do or if there is a script that i dont know.
I cant use update table, I need NULL fields to have NONE while i executing SELECT statment .



Thank-you for your HELP!!!!
progress.gif
 
1st time working with Progress!
Im pulling data using DecisionStream by Cognos. I need NULL fields to have 'NONE'.
When i'm trying to execute IFNULL (To_Char (cc_ctg), 'NONE'....... it's not working.
Please explain what should i do or if there is a script that i dont know.
I cant use update table, I need NULL fields to have NONE while i executing SELECT statment .

Using a raw Progress method, the NULL value will be stored by Progress as ?
Create a simple procedure / script to realize this or similar:
FOR EACH tableName WHERE fieldName = "whatEverValue":
ASSIGN
fieldName = "NONE"
.
END. /* EACH tableName */
This is simple Progress raw data method, it may not be pretty though it WILL work. Use this and apply as appropriate.
 
I'm pulling data as I stated from MFG pro thru Progress.
SELECT "cct_asd",
"cct_desc",
"cct_active"
FROM "tt_mstr2"
All i want is when cct_asd is pulled (character) if there is nothing there 'blank' i want 'NONE' to be inserted instead of EMPTY FIELD.
THANK-YOU!
 
You must log in or register to reply here.
Back
Top