The WebSphere Webfacing Tool
The Web Facing function (5250 DDS to JSP) is a standard part of the WebSphere Design Studio Client. There is a great Redbook out on the process also as well as numerous books from 29th STreet press. This facility will easily handle all the conversion and JSP work for you without having to touch a [...]

View Answer   |  November 16, 2004  10:15 AM
Development, E-business, Graphical User Interfaces, Hardware, i5, iSeries, Operating system platforms, OS/400, Programming Languages, Servers, Tech support, Web services, WebSphere Studio, Windows
answered by:
25 pts.

DB2 SQL delete to purge Header/Detail records
Recommend you use TYPE date instead of TYPE integer for nDate. In your SQL, a current date of 15 Nov 2004 gives: 20041115 – 30 = 20041085 (not a valid date)

View Answer   |  November 15, 2004  3:30 PM
DB2, SQL
answered by:
0 pts.

Counter
1. You need a form with the counter field(s) 2. Create the document, or your agent could do it if none exists. 3. Use a view for getting the document. 4. You could have more views with more counters etc. If you are going through the web, use WebQueryOpen on the form that is the [...]

View Answer   |  November 14, 2004  11:24 PM
Development
answered by:
0 pts.

V5R3 Upgrade
A few questions ….. are we talking MQ and if so, for which platform? Jerry

View Answer   |  November 12, 2004  11:14 AM
Development
answered by:
0 pts.

VB.Net and Internet Explorer
Does your app put some kind of page view information into session? If not, in c# I’d try something like: this.Page.GetPostBackClientHyperlink(); Not certain what you’re after, hth …

View Answer   |  November 12, 2004  8:10 AM
Development, VB.NET
answered by:
0 pts.

Uninstall Lotus Notes 6.5
If you can still see your Notes 5 directory then you are still OK and will be able to recover it if you can not see your Notes 5 directory then you have upgraded your Notes to 6.5. If you can see it rename it to something like oldnotes, uninstall notes 6.5 and reinstall notes [...]

View Answer   |  November 12, 2004  1:29 AM
Development
answered by:
0 pts.

Client Access file transfer – file override
I had a similar need. I tried building the transfer as a string and then using a variable in the STRPCCMD command but could not get that to work. I did not spend a lot of time trying to resolve this since I only had 10 different directories and just coded for all. I plan [...]

View Answer   |  November 11, 2004  11:49 AM
Development
answered by:
0 pts.

Text Files
if you write a text in a file with vb like with a print #1, text$ , there is no ” add around the string text . if you want to put some ” in the text you must add some chaine characters like toto$ & chr(34) & titi$

View Answer   |  November 10, 2004  10:46 AM
Development
answered by:
0 pts.

PL SQL Record in Java
PL/SQL RECORD type is not supported by Oracle JDBC. You will have to create a wrapper procedure that accepts the PL/SQL RECORD type from the original procedure and passes the individual components to JDBC using the supported types (CHAR, NUMBER, etc).

View Answer   |  November 9, 2004  10:22 AM
J2EE, Java, SQL
answered by:
0 pts.

PL SQL Record in Java-2
Try define the type globally (not within a package) CREATE TYPE ….

View Answer   |  November 9, 2004  8:51 AM
J2EE, Java, SQL
answered by:
0 pts.

RPGLE and Empty File-2
One problem with your solution: you read with error extender, so your else clause gets active when an error occurs. Better include a branch for error handling as well.

View Answer   |  November 8, 2004  2:34 AM
Development
answered by:
0 pts.

sap to sql transfer.
what level of involvement from the SAP programmers is avilable ? Simplest but involves SAP: Extract of recent updtates from SAP as a CSV, transsfer file, small VB6 or VB.NET service / program to update SQL. Or small VB6 or VB.NET service / program to read SAP & update SQL. David L.

View Answer   |  November 7, 2004  10:16 AM
Development, Networking, Tech support
answered by:
0 pts.

MQ Series processes issue
Our servers running 5.2 on Windows 2000 have multiple instances of those same executables as well and we have a straightforward installation, so it’s probably normal.

View Answer   |  November 6, 2004  10:36 PM
Data analysis, DataCenter, Development
answered by:
0 pts.

Images in Notes Rich Text Fields
I recommend that you read the IBM Redbook called: COM Toegther – with Domino http://www.redbooks.ibm.com/abstracts/sg245670.html?Open Only 158 pages if you read everything. You will only need to read about 80 pages to get started. This is an introduction to COM use with Domino. This will give you the basics you need to write VB Code [...]

View Answer   |  November 5, 2004  7:50 PM
Visual Basic
answered by:
0 pts.

Best IDE for building JSP pages
Altova XMLSpy 2005 is one of the latest jsp editors. IT has intellisense for quick coding and can also handle xml, xslt, etc.

View Answer   |  November 5, 2004  5:38 PM
BEA Systems, BEA WebLogic, C, Computer Associates, HTML, IBM, IBM WebSphere, J2EE, Java, JavaScript, JBoss, JSP, Servers, Sun, Sun ONE Application Server, Web development tools, WebSphere Studio
answered by:
0 pts.

Importing iSeries SpoolFiles in Windows
You probably have this information already, but, http://www.starquest.com/Supportdocs/techCA/chap3d.html Has some info about the cwbobj_REadsplf API. I am sorry i do not have experience with this. There were also hits on crtobj on www.search400.techtarget.com itself that might help.

View Answer   |  November 5, 2004  10:58 AM
ActiveX, AS/400, Java, Microsoft Windows, RPG, VB.NET, Visual Basic
answered by:
30 pts.

Scripts after SP2
Yes, add your site to trusted sites on the tools/options/security tab. Then go to custom level. I think popups are allowed by default on trusted sites, but you might have to change. -jim

View Answer   |  November 5, 2004  10:06 AM
JavaScript
answered by:
0 pts.

RPGLE and Empty File
could you not use: Open sFileName For Input As #1 if Len(sFileName)>0 then ‘ do something Else ‘ do something else End if sFileName should be full path of the file.

View Answer   |  November 4, 2004  7:02 PM
Development
answered by:
0 pts.

DOS mode printout from Crystal Report 9.0 thru VB6
Your question does not make sense. VB does not run in DOS mode.

View Answer   |  October 29, 2004  8:08 AM
Visual Basic
answered by:
0 pts.

String Search in Oracle SQL
Hi, you can try this: SELECT … FROM … WHERE … AND NOT INSTR(<your_field>, ‘LNCH’) > 0

View Answer   |  October 28, 2004  8:55 PM
SQL
answered by:
0 pts.