Model 170 – Problem creating PC5250 session
Dear All, I know what the problem is and what the resolution is (see below) but how do I create a 5250 session now in order to sign on to the AS400 and change the system value QAUTOVRT. (There is no Twinax connection on the 170 so no dumb terminal available.) Can you help ? [...]

Answer Question   |  December 25, 2009  5:24 AM
AS/400, PC/Windows Connectivity

can strqmqry be run as remote command
I am trying to run strqmqry via a dos/cmd ftp session. command: QUOTE RCMD STRQMQRY QMQRY(lib/qry) … where … are other options I followed various instructions posted here and on as400 tech sites on how to create the query. I was able to do all of that via a dos/cmd ftp session (except for editing [...]

Answer Question   |  November 9, 2006  4:52 PM
Application development, AS/400, Backup & recovery, CLP, Data analysis, DB2 Universal Database, PC/Windows Connectivity, Printing

MS SQL Server 2000
Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

Answer Question   |  November 13, 2006  12:53 AM
Access, Application development, Backup & recovery, CLP, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, DB2 Universal Database, Desktops, Email, IBM Marketing Sound Off, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Patch management, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Servers, SQL, SQL Server, Web development

SQL Stored procedure call via ODBC
Trying to call a stored procedure via ODBC, the CA400 ODBC driver uses the SQL (as opposed to SYS) conventions this works fine when procedure is created in QGPL and procedure is called with CALL QGPL.MyNewProcedure(Parm1,Parm2,Parm3) when the procedure is in another library then the call does not work CALL MYLIB.MyNewProcedure(Parm1,Parm2,Parm3) message is returned SQL0202 [...]

Answer Question   |  November 7, 2006  12:01 PM
DB2 Universal Database, PC/Windows Connectivity

security problem
Hello, I have small workgroup having 10 computers in my office. I do some personal work in office like using yahoo messenger, checking personal e-mails and some online banking site. But how does one of my senior knows it? I do everything lonely and securely so that nobody in the office knows it. But he [...]

Answer Question   |  February 19, 2008  3:44 AM
Access control, Application security, backdoors, Backup & recovery, Biometrics, Browsers, Career development, Compliance, configuration, CRM, Current threats, Data analysis, Database, DataCenter, DataManagement, DB2, Desktop management applications, Development, DHCP, Digital certificates, Disaster Recovery, DNS, Ecommerce applications, Encryption, Enterprise Desktop, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intel, Interoperability, Intrusion management, LANDesk, Lotus Domino, McAfee, Microsoft Systems Management Server, Microsoft Windows, Mobile security, Network security, Networking, Networking services, Oracle, patching, PC/Windows Connectivity, PEN testing, Platform Security, Policies, Postini, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Software, Spam, Spyware, SSL/TLS, Symantec, Systems management software, Tech support, Trojans, Vector Networks, Viruses, VPN, vulnerability management, Web security, Wireless, worms

need to take ownership of a folder
hi all, i’m using win xp sp1. not conected to any domain. i need to take ownership of some folders in my HD which created by one EX user. i tryd @ http://support.microsoft.com/kb/308421/en-us but in my system when i take property tab there is no Security tab . do any body can help me in [...]

Answer Question   |  October 27, 2006  7:49 AM
Backup & recovery, DataCenter, Hardware, Microsoft Windows, PC/Windows Connectivity, Storage, Tech support

Looking for a Jacada User Group
I am trying to determine if anyone has created a Jacada User Group or would be interested in starting a Jacada User Group. My company currently uses the JIS product.

Answer Question   |  November 2, 2006  4:07 PM
Application development, Development, PC/Windows Connectivity, Software, Web development, Web development tools

Connect:Direct CDSND command
Has anybody used this software to send data? We are sending a native file, and were wondering if there was a way to have the file converted to tab delimited on the CDSND command? Or, do we have to tab delimit it to the IFS and CDSND from there ?

Answer Question   |  October 21, 2006  5:43 AM
Application development, AS/400, CLP, DB2 Universal Database, PC/Windows Connectivity

Learning FTP from the bottom up…
Are there any good resources available on the web that can give me the basics (most often used/needed) FTP commands. Or, can anyone give me the details of the most commonly used commands. I’ve got to strart doing some FTP’ing in this new job.

Answer Question   |  October 11, 2006  4:59 AM
AS/400, DataCenter, Email, PC/Windows Connectivity, RPG, RPGLE

Secure FTP from I5 Windows.
We have an I Series running V5R3. We need to be able to send a file from our I5 to a bank ftp server, securely. Right now the banks ftp is unsecured. What steps would we need to do on our end? I assume that since the bank is providing the ftp server, they would [...]

Answer Question   |  December 23, 2009  4:26 PM
AS/400, PC/Windows Connectivity

Transfer Data to iSeries from Excel
I have some VB code that reformats some data in an Excel workbook. The last step of my code needs to transfer a range of cell to an existing file on the iSeries using an existing data tranfer definition. Is there a way to invoke the dialog box that supports the upload of data to [...]

Answer Question   |  September 26, 2006  2:24 PM
PC/Windows Connectivity, Visual Basic

Help with PCCMD and windows variable%UserProfile%
hi everyone, i’m trying to help one of my friend who is using this command: STRPCCMD PCCMD (‘rtopcb /s %userprofile%FAVCONVOconvo.tto’) %Userprofile% is the environment variable which roots me to C:documents and settingsProfile name. We tried to put this variable into ” ” but it did not work either…By any chance, does anyone know how can [...]

Answer Question   |  October 16, 2006  10:02 AM
Application development, PC/Windows Connectivity

FTP session
During an FTP session, prior to issue the GET command to receive files from a remote site to my local server, I need to clear my local directory. Is it possible to delete files from the local server ?? kind of a DEL or MDEL command that would be executed locally instead of the remote [...]

Answer Question   |  September 12, 2006  2:42 PM
Application development, AS/400, DataCenter, PC/Windows Connectivity

iseries navigator
Hi. I got a new laptop and had to install iSeries Access from strach. Its working, exept iSeries Navigator (cwbunnav.exe has encountered a problem and needs to close)(AppName: cwbunnav.exe AppVer: 10.0.0.2 ModName: cwbunjas.dll ModVer: 10.0.0.0 Offset: 00011000). Laptop OS is XP SP2, Service Level is SI24723. Can you please help me solve this problem? Regards

Answer Question   |  September 4, 2006  7:47 AM
PC/Windows Connectivity

transferring PDF from IFS to network server
Hi, I need to get some PDF reports from the IFS of our iSeries(V5R2) and put them on our network server. What is the best way to do this? I need to automate the process so that it will run every day. Thanks, MissieStar

Answer Question   |  August 9, 2006  4:26 PM
PC/Windows Connectivity, Printing

Stored Procedures on AS/400
Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks for [...]

Answer Question   |  December 14, 2009  10:58 AM
Application development, AS/400, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, RPG, RPGLE, SQL, SQL Server, Web development, Web development tools, WebSphere Studio

runrmtcmd on WinXP
I can’t seem to get mapped drive operations to work from batch pgms on WinXP called using runrmtcmd. For instance, I have a .bat file that does a “dir c:”. This works if I run the batch file from a command window on XP and it also works if I invoke it using runrmtcmd from [...]

Answer Question   |  November 24, 2010  10:25 PM
AS/400, DataCenter, Microsoft Windows, PC/Windows Connectivity

Retrieval of Extended Source Library Information
Is there a way via FTP to retrieve additional source code line-level details (sequence #, date line of code was changed) from iSeries RPG/CL source libraries? If not via FTP, is there another way to extract and transfer this information?

Answer Question   |  December 14, 2009  3:58 PM
AS/400, DB2 Universal Database, PC/Windows Connectivity

Help with converting Mainframe file on iSeries
Hi there, I’m looking for some advice/help on a file that I’m having some trouble with. The file originates from a mainframe, and is sent over to our iSeries (V5R2M0) via Connect:Direct. The file is 3680 Bytes long, comprising of string and compressed numeric data. I have the layout of the file, although it’s in [...]

Answer Question   |  December 13, 2009  7:38 AM
AS/400, DB2 Universal Database, PC/Windows Connectivity

Source highlighting using NetManage Rumba
Has anyone developed a keyboard macro, VB Script or WSCST object that will let you enter the hex values necessary to highlight source code in SEU while using Rumba? I found a few examples for CA/400, but not for Rumba. TIA…Chuck

Answer Question   |  December 18, 2009  8:52 PM
Application development, AS/400, DataCenter, PC/Windows Connectivity, RPG, RPGLE