-
Can you transfer active jobs to another subsystem?
If a job is already active in one subsystem, can you use tfrbchjob or tfrjob to move into a different job queue to run in a different subsystem, or will you get errors because the job is already active in one subsystem?
Last updated: -
CPIB687 conflicting announcement for domain
In Qsysopr we get a CPIB687 message reason code 3. It references a conflict announcement for the domain that it is in along with our AS400. WE know how to disable the master browser settings on windows clients. This is a MAC client and we do not know how to disable it. IBM set we can change our...
Last updated: -
Is it possible to have multiple telnet ports listening at the same time for telnet connections on the iSeries? (i.e., the normal port 23, plus one or two additional ports to split traffic, etc.). If so, do you have to configure / start multiple telnet servers on the iSeries (one for each specified...
Last updated: -
New to AS400 administration and need some help.
I have two questions here if someone can help. I will appreciate anything you can give. First, I am trying to configure a network printer on the AS400. I did wrkcfgsts, work with description, and copied the printer devices description and modified the printer device with the new info. All I changed...
Last updated: -
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...
Last updated: -
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....
Last updated: -
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
Last updated: -
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
Last updated: -
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...
Last updated: -
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....
Last updated: -
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...
Last updated: -
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...
Last updated: -
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?
Last updated: -
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...
Last updated: -
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 Any idea where I am going wrong please?
Last updated: -
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...
Last updated: -
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...
Last updated: -
Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?
Last updated: -
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...
Last updated: -
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...
Last updated: