When creating a SYNONYM for a Progress Table I have a problem with one of the fields that contains comma-delimited data. When replacing the data with a plain text string (e.g. "XXXX") everything works fine. When the field contains the comma-delimited data, the system becomes unresponsive (hangs up).

Below is an example of the data in the comma-delimited field.

",,,2600,Total By Customer Group,7072371.33,2276371.65,588249.15,606576.57,485586.45,376432.76,352981.31,5901372.47,17659941.69,1227828.46"

My assupmtion is that the system does not allow a field to contain delimited values. I have replaced the comma with a pipe ("|") delimiter, but that also does not work.

Unfortunately I don't have control of the source data in Progress and have to use it as is.

Any suggestions would be appreciated!

Mollie Kruger

This message has been edited. Last edited by: <Emily McAllister>,

Hi Mollie and welcome to the Forum!
How is your field defined in Progress? VARCHAR?
Is it the SYNONYM creation that hangs or when you try to retrieve data?

Hi Danny,

The field in Progress is a varchar. As I have mentioned, if I replace the data with a plain text string (e.g. "XXXX") it is fine.

The creation of the synonym is successful. As soon as I retrieve sample data, it hangs up.

Mollie,
Next question: what is your output? HTML? PDF? XL?
If you issue a simple TABLE, e.g.

 
TABLE FILE progresstable
PRINT molliefield
IF READLIMIT EQ 10
END 

Does it still hang?

What hangs? Is it the WebFOCUS server, or the web-browser or perhaps even the Progress server?

What is the length of the varchar field in Progress and what is the field definition (mostly the ACTUAL and USAGE values) in the master file?

It's possible that WF automatically created a master file that has incorrect field lengths and that that's causing problems.

To test that, does 'it' still hang when you replace the value with a non-delimited string of the same length? What about half the length? What about in between those two? Yeah, that's a binary search to find out what length it does accept (and the USAGE length from the master would probably be an excellent starting point for that search!).

What's the synonym look like and which column in it is the problem. WHat's the data source?

Hi all,

I managed to convince the Progress DBA to dump the data I require into another table which does not contain a delimited field. All happiness!

Tahnks for all the replies.