transferring files from iSeries to PC
Does anyone know of a way to transfer a file from the iSeries to a pc using CLP or RPGILE? I do not want the user to have to run a client access transfer. I would like the user to be unaware that this transfer has been done. thanks
Does anyone know of a way to transfer a file from the iSeries to a pc using CLP or RPGILE? I do not want the user to have to run a client access transfer. I would like the user to be unaware that this transfer has been done. thanks
0 pts.
Source Modified User
Hi All, If 4 users works on in same library in one source file, How could we know which user has modified a source? Thanks Reddy
Hi All, If 4 users works on in same library in one source file, How could we know which user has modified a source? Thanks Reddy
CA Express download from iSeries to excel
I really really need help finding a solution to this problem. We have users that download files from the iSeries using Client Access Express into excel. The problem is that when the report comes up in excel the negative numbers have the minus sign to the right of the number instead of the left. ...
I really really need help finding a solution to this problem. We have users that download files from the iSeries using Client Access Express into excel. The problem is that when the report comes up in excel the negative numbers have the minus sign to the right of the number instead of the left. ...
Select last 3 transactions
Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...
Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...
Tracking Changes to Files
Requirement:- To track any changes to Two files A and B and write fields of A and B to an output file C. A is related to B (A.Employee = B.Employee) Could you please suggest a good approach for this? I am currently using the approach of journalling. 1. Both A and B are journalled. 2. If Any...
Requirement:- To track any changes to Two files A and B and write fields of A and B to an output file C. A is related to B (A.Employee = B.Employee) Could you please suggest a good approach for this? I am currently using the approach of journalling. 1. Both A and B are journalled. 2. If Any...
browser
I have to invoke a browser from as/400 with authentication by sending sensitive information as paremeters. The browser will take tbe parameters and get the data from i-series and display the information in the browser. any help in how to invoke the browser with paramaters would be helpful as...
I have to invoke a browser from as/400 with authentication by sending sensitive information as paremeters. The browser will take tbe parameters and get the data from i-series and display the information in the browser. any help in how to invoke the browser with paramaters would be helpful as...
Trying to publish a Webfacing Project
Using WebSphere Development Studio I've created a WebFacing project converted an existing application on our iSeries to a WebFaced application, but i can only access the WebFaced application from my PC. How publish the application to a web server so that other users can access it. I tried exporting...
Using WebSphere Development Studio I've created a WebFacing project converted an existing application on our iSeries to a WebFaced application, but i can only access the WebFaced application from my PC. How publish the application to a web server so that other users can access it. I tried exporting...
Copy files from other systems into IFS folder via Windows Explorer
How can we copy xls or txt files from other systems into IFS folder using Windows Explorer? Using iSeries v5r4. We can display files from IFS folder using internet explorer. What type of config do we need to do? What type of security access do users need to have? Can you send documentation on this?
How can we copy xls or txt files from other systems into IFS folder using Windows Explorer? Using iSeries v5r4. We can display files from IFS folder using internet explorer. What type of config do we need to do? What type of security access do users need to have? Can you send documentation on this?
Copy file from windows to iSeries Optical Library using navigator
We have a network folder on our Windows workstation that contains word documents that we backup yearly. I have created a bat file to copy out just the 2006 files and put them in individual monthly folders (Jan2006, Feb2006, etc.). I would like to copy these folders to our optical library...
We have a network folder on our Windows workstation that contains word documents that we backup yearly. I have created a bat file to copy out just the 2006 files and put them in individual monthly folders (Jan2006, Feb2006, etc.). I would like to copy these folders to our optical library...
Windows Scheduling iSeries Data Transfer
I have 4 data transfers created in IBMs data transfer from iSeries Server programs that I need to schedule using Windows Scheduler. I can make the transfers work by double clicking on the .dtf but when I try and schedule them I get the following errors: filename, directory name, or volume labe...
I have 4 data transfers created in IBMs data transfer from iSeries Server programs that I need to schedule using Windows Scheduler. I can make the transfers work by double clicking on the .dtf but when I try and schedule them I get the following errors: filename, directory name, or volume labe...
Using Client Access while on VPN
We have just converted from a iSeries 270 V5 R1 to a 520 V5 R3. The system values on both systems are the same. The remote users who attach to the network using a VPN then starting Client Access no longer work. The 270 was not defined in our firewall and we were able to connect. The 520 is a LPAR...
We have just converted from a iSeries 270 V5 R1 to a 520 V5 R3. The system values on both systems are the same. The remote users who attach to the network using a VPN then starting Client Access no longer work. The 270 was not defined in our firewall and we were able to connect. The 520 is a LPAR...
FTP from iSeries to PC
I have installed a Cerberus FTP Server on the PC and I need to FTP a flat file FROM the iSeries TO the PC. However, when I enter the PUT statement it returns with : 227 Entering Passive Mode (213,210,55,130,4,22) 425 Unable to open the data connection ...
I have installed a Cerberus FTP Server on the PC and I need to FTP a flat file FROM the iSeries TO the PC. However, when I enter the PUT statement it returns with : 227 Entering Passive Mode (213,210,55,130,4,22) 425 Unable to open the data connection ...
iseries Client Access
We have several PC workstation with "static" assigned workstation ID's. Lately these static ID's have been showing up in the "pool" and being assigned to whoever happens to start a client access session, instead of the default QPADEVxxxx workstation ID. This then causes the person who "owns" the...
We have several PC workstation with "static" assigned workstation ID's. Lately these static ID's have been showing up in the "pool" and being assigned to whoever happens to start a client access session, instead of the default QPADEVxxxx workstation ID. This then causes the person who "owns" the...
Front End Development for AS400
Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some initial research on that and...
Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some initial research on that and...
iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB - real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files...
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB - real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files...
Incoming Remote Command on Windows XP
I've been able to find lots of entries on the IBM site for Incoming Remote command and SE, ME, NT and 2000 but there is something different with XP that prevents it from working. Has anyone been able to make the incoming remote command work to an PC running XP?
I've been able to find lots of entries on the IBM site for Incoming Remote command and SE, ME, NT and 2000 but there is something different with XP that prevents it from working. Has anyone been able to make the incoming remote command work to an PC running XP?
Renaming a file in the IFS directory
I am receiving a file daily in an IFS directory, I manually copy the file to a library using the CPYFRMSTMF command. I want to automate the process so that it will be done every day at a specific time. The challenge is that the file name in the IFS directory is different every day, for example it...
I am receiving a file daily in an IFS directory, I manually copy the file to a library using the CPYFRMSTMF command. I want to automate the process so that it will be done every day at a specific time. The challenge is that the file name in the IFS directory is different every day, for example it...
iSeries Access and 5250 Session Disconnects
I have a client with a Dell Laptop that is connecting to an i5 520 system with iSeries Access V5R3. The 5250 sessions will not stay connected. All other PC and telnet devices have no problems stating connected. I believe the issue is associated with the Microsoft updates associated with the Laptop....
I have a client with a Dell Laptop that is connecting to an i5 520 system with iSeries Access V5R3. The 5250 sessions will not stay connected. All other PC and telnet devices have no problems stating connected. I believe the issue is associated with the Microsoft updates associated with the Laptop....
Db2/AS400 library connecting via oledb in vb.net
I have been trying to connect a vb.net datalink property to a specific library on a 400. When I fill in the field "Enter the initial catalog to use" I get the message that the catalog is invalid. I have thought it might be a path on the 400, such as QSYS/MyLib, but that errors as well. What am...
I have been trying to connect a vb.net datalink property to a specific library on a 400. When I fill in the field "Enter the initial catalog to use" I get the message that the catalog is invalid. I have thought it might be a path on the 400, such as QSYS/MyLib, but that errors as well. What am...
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 ? PC5250 Displays...
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 ? PC5250 Displays...
