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...
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...
0 pts.
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?
Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?
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...
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...
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....
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....
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 this ?...
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 this ?...
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.
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.
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 ?
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 ?
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.
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.
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 be responsible for making their...
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 be responsible for making their...
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 the iSeries from...
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 the iSeries from...
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...
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...
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 side..
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 side..
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...
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...
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
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
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? ...
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? ...
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 an iSeries session or CL...
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 an iSeries session or CL...
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?
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?
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,...
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,...
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
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
AS400 name not resolving in DNS
On Sunday I restarted my AS400 prior to doing my monthly full system back up. When it came on line, none of my PC's could resolve the system name (s10a####) to the internal ip address. I entered a DNS entry manually on my internal Windows 2003 DNS server, and all the PC's running XP pro can connect...
On Sunday I restarted my AS400 prior to doing my monthly full system back up. When it came on line, none of my PC's could resolve the system name (s10a####) to the internal ip address. I entered a DNS entry manually on my internal Windows 2003 DNS server, and all the PC's running XP pro can connect...
