prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
August 23, 2007, 04:51 PM
Albert Ceccucci
Try creating a temporary FOCUS file and insert records into it using the MODIFY FILE command along with the FREEFORM statement. The FREEFORM statement reads comma-delimited data, you'll first have to save your data.
define file xxx commma/a1 = ','; endofline = '$'; end
table file xxx print cliendid comma verylongstring comma endofline on table save end
Now use a MODIFY FILE with FREEFORM to read the save file.
Regards,
August 23, 2007, 05:17 PM
Francis Mariani
How about creating a master with OCCURS?
If the original table is an RDBMS, create a HOLD file and then use a different master with OCCURS.
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 23, 2007, 10:01 PM
Piipster
Isn't this a good example of where to use McGuyver? Split up verylongstring into multiple fields using GETTOK and then use Mcguyver to print them out one over the other.
ttfn, kp
Access to most releases from R52x, on multiple platforms.
August 24, 2007, 06:06 AM
hammo1j
I think this would be nice - if IBI built in MCGUYVER technique directly into wf. The MULTIPLY command would have syntax and usage similar to the JOIN command.
MULTIPLY filename[.segname] n TIMES
This would mean the record retrieved once and then passed n times to the matrix with dummy field filename.segname.MULTIPLE which varied from 1 to n.
This would give wf a lot of extra functionality with a relatively simple implementation.
Once you're done: MULTIPLY CLEAR ! And ? MULTIPLY
I can only dream on...This message has been edited. Last edited by: hammo1j,
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
When I posted my question I thought al the numbers in the longstring where of equal length, but in the meantime I found that they are not, some are 7 and some are 9. I will try to combine some tips here and see if I will get it work
Thanks
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
August 24, 2007, 02:49 PM
Albert Ceccucci
If your field lengths are different then try this:
The Input file is as follows:
Client ID Long Value --------- ---------- 12345 '9234','9932','97','936269','939292' 82836 '921438','913432','917' 82805 '991234','953221','912','915347','917','969','939292'
Master file is now (similar to earlier post -- no COMMA field in SEGNAME TWO: