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
View Answer
| Jul 23 2007 2:48 PM GMT
| asked by
Laurie9
Application development, CLP, PC/Windows Connectivity
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?ThanksReddy
View Answer
| Jul 2 2007 5:25 AM GMT
| asked by
NarasimhaReddy
AS/400, Application development, Backup & recovery
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. ...
View Answer
| Jun 13 2007 9:57 AM GMT
| asked by
283900
AS/400, PC/Windows Connectivity, Software
Select last 3 transactions
HelloCan 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, Amountfrom Transwhere CustID= '12345'order by TransDate desc.I believe there must be a more effcient way...
View Answer
| May 22 2007 6:54 AM GMT
| asked by
SuhelAC
DB2 universal database, PC/Windows Connectivity, Data analysis
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 changes to...
View Answer
| May 11 2007 5:44 AM GMT
| asked by
AyeYes400
AS/400, Application development, Backup & recovery
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 soon...
View Answer
| Mar 29 2007 7:09 AM GMT
| asked by
veen781
AS/400, PC/Windows Connectivity
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...
View Answer
| Mar 14 2007 11:48 AM GMT
| asked by
slaliberte
AS/400, Application development, PC/Windows Connectivity
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?
View Answer
| Mar 12 2007 5:02 PM GMT
| asked by
KobiDutch
PC/Windows Connectivity
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...
View Answer
| Feb 7 2007 4:22 PM GMT
| asked by
CasNowak
AS/400, PC/Windows Connectivity
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...
View Answer
| Feb 5 2007 3:40 PM GMT
| asked by
heather400
AS/400, DB2 universal database, PC/Windows Connectivity
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...
View Answer
| Jan 31 2007 3:46 PM GMT
| asked by
Phillipsf
AS/400, PC/Windows Connectivity
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 ...
View Answer
| Jan 17 2007 10:38 AM GMT
| asked by
selectsoft
AS/400, Application development, PC/Windows Connectivity
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...
View Answer
| Jan 11 2007 5:51 PM GMT
| asked by
cgraves
AS/400, PC/Windows Connectivity
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...
View Answer
| Jan 3 2007 10:39 AM GMT
| asked by
pgsdeb
AS/400, Application development, CLP
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...
View Answer
| Dec 27 2006 10:35 AM GMT
| asked by
JohndeCoville
DB2 universal database, PC/Windows Connectivity, DataManagement
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?
View Answer
| Dec 24 2006 3:30 PM GMT
| asked by
JDWWms
AS/400, PC/Windows Connectivity
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...
View Answer
| Dec 14 2006 3:53 PM GMT
| asked by
hmonat
AS/400, Application development, CLP
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....
View Answer
| Dec 7 2006 1:47 PM GMT
| asked by
hafwhit
AS/400, PC/Windows Connectivity
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...
View Answer
| Nov 24 2006 8:40 PM GMT
| asked by
vatrix
DB2 universal database, PC/Windows Connectivity
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 E8940...
View Answer
| Nov 13 2006 5:24 AM GMT
| asked by
rockgirl
AS/400, PC/Windows Connectivity
