PC/Windows Connectivity Questions and Answers

Recent IT Questions

1 - 20 of 99
<<PREVIOUS 1|2|3|4|5 NEXT>>

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
PC/Windows Connectivity, Application development, CLP
asked by Laurie9

  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

View Answer   |  Jul 2 2007  5:25 AM GMT
AS/400, Security, PC/Windows Connectivity
asked by NarasimhaReddy

  155 pts.

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
AS/400, PC/Windows Connectivity, Software
asked by 283900

  5 pts.

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...

View Answer   |  May 22 2007  6:54 AM GMT
Oracle, PC/Windows Connectivity, SQL
asked by SuhelAC

  0 pts.

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...

View Answer   |  May 11 2007  5:44 AM GMT
AS/400, Security, PC/Windows Connectivity
asked by AyeYes400

  0 pts.

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...

View Answer   |  Mar 29 2007  7:09 AM GMT
AS/400, PC/Windows Connectivity
asked by veen781

  5 pts.

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
AS/400, PC/Windows Connectivity, RPG
asked by slaliberte

  5 pts.

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
PC/Windows Connectivity
asked by KobiDutch

  0 pts.

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
AS/400, PC/Windows Connectivity
asked by CasNowak

  0 pts.

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
Tech support, AS/400, Security
asked by heather400

  0 pts.

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
AS/400, PC/Windows Connectivity
asked by Phillipsf

  0 pts.

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
AS/400, PC/Windows Connectivity, Application development
asked by selectsoft

  65 pts.

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
AS/400, PC/Windows Connectivity
asked by cgraves

  5 pts.

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
AS/400, PC/Windows Connectivity, Application development
asked by pgsdeb

  5 pts.

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
Security, Oracle, PC/Windows Connectivity
asked by JohndeCoville

  0 pts.

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
AS/400, PC/Windows Connectivity
asked by JDWWms

  0 pts.

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
AS/400, PC/Windows Connectivity, Application development
asked by hmonat

  20 pts.

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
AS/400, PC/Windows Connectivity
asked by hafwhit

  630 pts.

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
PC/Windows Connectivity, DB2 Universal Database
asked by vatrix

  0 pts.

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...

View Answer   |  Nov 13 2006  5:24 AM GMT
AS/400, PC/Windows Connectivity
asked by rockgirl

  20 pts.

1 - 20 of 99
<<PREVIOUS 1|2|3|4|5 NEXT>>