Search results for query: *

Hi SUSANNAH, I, too, was a former occupant of the Focus CMS environment. Things were so much simpler there! Anyway, the SLEEP command does work in WebFocus - but only after the DOS copy command has finished - so it does not really help. I also tried the CMD copy command, as you suggested but...

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...

I've often had this problem and have been occasionally able to solve it by reducing the the size of the column headings which may have been wider that the actual column contents. Also, try reducing the margins on each side of the page, possibly by setting the stylesheet margin parameters, for...

If you're passing parameters between different fex's, you must use double-ampersand variable field names, i.e. call your field &&RPTNAME. You can reset this at the end by saying: -SET &&RPTNAME =;

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...

I'm still getting this problem. Can anyone help? Is Focsort short of disk space? Can I increase it? The Focsort file is actually on the disk but WF seems unable to see it..... error this morning: 08/12/2005 06:53:17 u=PFitzger, pid=2880: Error accessing FOCUS file focsort.foc, FOCUS name FOCSORT...

Hello, I'm not using EDASTART (I can't seem to find it anywhere in WF 431), so I use WFMOBILE instead and it has worked OK for years. Basically, I point it at a fex where there is a series of EXecute statements, one for each of the imbedded fex's, each of which is followed by a -RUN. It is the...

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, The actual code is shown below..... I can't recall the exact message but SQLOUT was mentioned as being the fex in error and OUTPUT1 as being the file which couldn't be written, though approx 14,000 records had been written at this stage out of a total of approx. 480,000. This problem has...

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 Jimster06, Thanks for this tip; It could be used if I cannot set the width appropriately. I have used MF Focus and been able to output up to 512 characters. The WebFocus limit seems to be between 300 and 400. Hi Craigiep, Unfortunately, neither COM nor COMT seem to be supported on my...

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!

Have you tried SET ALL = ON

Hi Wayster, I usually reset all such varialbles, whether local (&) or global (&&), by: -SET &&ST_YR_WK =; -SET ..... -RUN Peter.

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, I've used wfmobile as a scheduled task, like this: C:\Ibi\desktop43\home\bin\wfmobile.exe EX C:\IBI\APPS\DB2\DB2AUTO.FEX ...my DB2AUTO.FEX looks like this: SET USERPATH= C:\IBI\APPS\DB2 -RUN EX PROFILE -RUN EX SETFILES -RUN EX REPORTS -RUN -QUIT FOCUS Peter.

Greg, Thanks for your perseverence. 1. When importing a comma-delimited file, Focus (a) needs the fields to be comma separated (b) will handle single quotes (or no quotes) around fields and (c) needs a ,$ at the very end as an end-of-record indicator. 2. It can handle 'fixed' files also -...

Hi Greg, Command 1: DB2 - TVF EXPORT1.SQL >C:\IBI\PGFTEMP\TEST.TXT EXPORT1.SQL script: SELECT SO_STATUS_NEXT_ID || ',' || SO_STATUS_NEXT_DESC || ',' || '$' FROM E6DW_DATA.SOT_LU_STATUS_NEXT WHERE SO_STATUS_NEXT_ID <= '999' WITH UR; - this gives the big long line in TEST.TXT, as follows...