Search results for query: *

Using WebFocus, how can I ensure when calling a DOS command via the SYSTEM command, that sufficient time is allowed for the operation is complete? Is there some way to "pause" the fex until the DOS command has completed? I'm having occasional problems when the DOS command takes more than 5 or 6...

Hi All, I've come across this before but usually managed to get around it by 'fixing' the offending character. What's happening is that I'm reading a DB/2 file using ODBC and outputting the results onto an alpha hold file. So far, so good. However, some of the data has imbedded accents and when...

Hi All, I'm running WF 431 under Windows 2000 and am having occasional difficulties with FOCSORT.FOC. I got this message in the EDAPRINT log this morning when running an un-attended overnight operation. There's plenty of space on the output disk and I've also tried to erase the FOCSORT file...

Hi All, I need to record Focus activities, as recorded in the console log, in a file for later verification as I will be running jobs un-attended overnight using the 'wfmobile' feature. In my former VM environment, I simply spooled the console of the virtual machine and everything was recorded...

Hi All, I'm getting the above message intermittently when writing a format ALPHA hold file of approx. 408,000k in size resulting from an SQL ODBC query, using Windows 2000 and WebFocus 431. It seems to go so far then stop. If you try again, it's OK. Any ideas on what the matter might be? Many...

Hi, What is the maximum width for a Lotus hold file and can this setting be changed? Thanks.

I am currently running WF 431 under Windows 2000, though I'm sure it was originally designed for an earlier version of Windows, possibly W98. I'm getting a new p.c. which will have XP as the default operating system. Will WF work in this environment or will I need to install W2000? Thanks!

Hi All, It's all a bit new to me and I know how to do this in other languages, so can anyone please help me? I want to define a temporary field and then use it as a filtering condition, like this..... SELECT (SNAP.SO_VIEW_ID || SNAP.SO_STATUS_LAST_ID ||...

Hi All, This is really a DB/2 SQL question but one of you WebFocus experts has probalbly have done something like this before..... I'm trying to export a DB/2 table in a comma-delimited format, suitable for later loading into WebFocus. When I issue the command: EXPORT TO...

Hi All, I'm trying to export a DB/2 table in a comma-delimited format, suitable for later loading into WebFocus. When I issue the command: EXPORT TO C:\IBI\PGFTEMP\EXP_STAT.TXT OF DEL SELECT SO_STATUS_NEXT_ID, SO_STATUS_NEXT_DESC FROM E6DW_DATA.SOT_LU_STATUS_NEXT WHERE...

Hi All, This is a really easy one for someone.... I use "SQL SQLODBC SET USER SOURCE/userid,password" to connect to a DB/2 data source; How do I disconnect from the source? When running SQL directly, I issue a "connect reset" - what is the WebFocus equivalent? Many Thanks.....

Hi All, I'm trying to squeeze a report onto one A4 page but I find that no matter how much I reduce the top/bottom margins in the stylesheet, there is still about 2 cm of blank space on the top of the page - and my report is needlessly going to 2 pages. Is there a setting somewhere which I can...

Hello All, Hopefully, this may be simple one for you DB2 experts out there - it's all new to me. I run this command: "C:\Program Files\IBM\SQLLIB\BIN\DB2CMD.exe" /c DB2SETCP.BAT DB2.EXE -tvf export.sql It works fine and produces this screen output: connect to e6dwprod user...

Hi All, I'm writing a focexec where, towards, the end, I need to intervene and change the contents of a hold file (.ftm format) before doing a MODIFY based on the altered contents. My problem is that I'm unable to edit the hold file using DOS EDIT or Wordpad. I can, of course, stop the fex...

Hi, I'm trying to generate graph files to deploy on our intranet website but the graphs being outputted by Focus don't seem to be standalone, i.e they seem to need the Focus environment to be displayed. It seems they have some kind of Java code imbedded in them. Also, when I specify GIF...

Hi All, I'm generating a graph file (HTML format) and when this happens, WebFocus issues a message saying that the HTML file has been created. I then have to click an OK button to continue. This is fine for interactive sessions but it causes unattended operations to stop as the system waits for...

Hi All, I'm looking for some setting where the DOS command timeout interval can be increased. Any suggestions? I'm running overnight applications using wfmobile and one imbedded DOS copy command is copying a file of circa 30,000 records. Focus displays a prompt asking if I want to keep waiting...

simple program..... FILEDEF OFFLINE DISK C:\OFFLINE.TXT OFFLINE TABLE FILE BLAH PRINT * END ONLINE FILEDEF OFFLINE PRINTER I would expect this to put the report output in the file OFFLINE.TXT What happens is that the report goes to the file, the file is printed and then erased. I want to keep...

Hi All, I'm in the process of migrating some of my VM Focus applications to Webfocus 4.3.1 and I'm looking for an equivalent facility to CRTFORM, whereby a screen containing pre-determined variables can be displayed to the user, to change if necesssary, press the Enter key and the program...

Hi, I'm new to all this SQL stuff, so any help is appreciated... I get the following message when running the TEST5 fex. It looks like some value is being exceeded somewhere. There are 87 fields on the incoming FAT_BSE_SALES_ORDER file, which is being read from DB2/NT via the ODBC client. EX...