When I run exec dbo.subprogram from sql server management studio, it executes and returns result as many rows affected: But when I run from cmd C:Usersmssadmin>sqlcmd -S servername -d databasename-q “EXIT( exec dbo.subprogram)” it retunrs as 0 rows affected. What could be the problem
Answer Question | October 11, 2012 9:55 AM
Please let me know how to omit one particular IFS file from daily backup. The IFS ( /QIBM/UserData/OS400/ResourceMonitoringControl/var/vpd/Hardware.xml) is not being saved on daily backup due to job lock. Hence user requests us to omit this file from backup. Please assist me to omit the IFS file.
Answer Question | October 10, 2012 6:38 PM
AS400 backups, BRMS
Hello. This week one of our AS400 got me all surprised. I do not know what to do, where to look, so I would like to ask here…just in case. On this AS400, among others there are four host table entries. These entries are set to 2.xxx.xxx.xxx addresses. The DNS has 9.xxx.xxx.xxx addresses. Customer does…
Answer Question | October 11, 2012 4:55 PM
AS/400, DNS, Host table, PTF, TCP/IP
So I am giving a good effort into writing a CL/CMD pair to start one of our programs from the command line, but I’ve hit a snag. Here is my CMD source: CMD PROMPT(‘Start Engine’) PARM KWD(PGM) TYPE(*NAME) LEN(10) DFT(‘TRAN_ENGV2′) PROMPT(‘Engine Program Name’) PARM KWD(PATH) TYPE(*PNAME) MIN(1) PROMPT(‘IFS Directory’) PARM KWD(PORT)…
Answer Question | October 10, 2012 3:31 PM
CL, CMD Source, i7, V7R1
Can i use single cursor for multiple SQL statements? ex: declare c1 cursor for select * from ……. also declare c1 cursor for select * from xxx
Answer Question | October 10, 2012 11:37 AM
SQL statement, SQLRPGLE
How can we restrict a particular user to the newly created objects in a particular library. By default the objects creating as *public with *CHANGE authority and this user having the access for newly created objects, so please let me know the steps or procedure to restrict this user for newly created in objects. By…
Answer Question | October 10, 2012 8:01 AM
AS/400, AS/400 objects
We have boca printer for printing tickets , when we disconnect and connect printer it appears to be connected but we have lots of messages say “unable to obtain lock on prtxx device prtxx” in the message Q.. we tried lots of commands such vrycfg , wrkobjlck , wrkwtr … it never response giving the…
Answer Question | October 9, 2012 10:05 PM
Printing AS/400 performance
we have boca printers for printing tickets … when we disconnect printers and reconnect it again a lots of messages appears in the message q say “unable to obtain lock on device” we tried vrycfg , wrkwtr , and other commands we tries also to change the writer configuration it says ” prtxx not eligible…
Answer Question | October 9, 2012 2:43 PM
Printing AS/400 performance
Hi guys, I need to copy all the objects(both DB file and PGM) from a library to another library except the source file(PF-SRC). I tried DSPFD FILE([file library]/*ALL) TYPE(*BASATR) OUTPUT(*OUTFILE) OUTFILE([outfile library]/[outfile]) then selecting those records where ATDTAT = ‘S’. But the outfile consists of only DB files. But I need RPGLE/CLLE program names also.…
Answer Question | October 8, 2012 9:20 AM
CLLE, iSeries V5R4MO
I use WRKQRY to produce a summary file. I use ’5′ to indicate the counting on a special field. The counts is larger than 9,999,999. I got field overflow. How to expand the counter field?
Answer Question | October 8, 2012 9:25 PM
AS400 -WRKQRY, WRKQRY
How to move tapes from I/O slot to storage slot via BRMS
Answer Question | October 5, 2012 6:48 PM
I am executed the below statements using CL. FileA got deleted. I want to know the reason. Please help me to understand the logic. PGM OVRDBF FILE(TESTPF) TOFILE(TESTPF1) OVRDBF FILE(TESTPF1) TOFILE(TESTPF2) OVRDBF FILE(TESTPF2) TOFILE(TESTPF) DLTF FILE(TESTPF) DLTOVR FILE(*ALL) ENDPGM FILEA got deleted. What is the reason?
Answer Question | October 4, 2012 11:10 AM
We’re running V7.1 and are running into an issue with about 5-7 users that are disabled daily from the mapped drive to the IFS. All of our users have the drive map on login and all of our username and passwords are different on the Windows and iSeries side but it’s only effecting 5-7 users.…
Answer Question | October 3, 2012 8:36 PM
Communications, Mapped Drive, NetServer, V7R1
Help…please I have a canon mp250 as a local printer. I cannot get the as400 to print to it. I have created a session for in dev config but still no joy. Client access printer options do not have a printer selection for canon. When I send a print to the printer it sends the…
Answer Question | September 28, 2012 7:40 AM
How do I move a tape drive between 2 LPAR’s without having to do it manually?
Answer Question | October 9, 2012 1:23 AM
LPAR, Tape Drive
If I clean a library on Tuesday and the AS400 server falls down on Wednesday afternoon, Does the full system restore a full library ( full backup and incremental of Monday night) or an empty library on Wednesday night (with Tuesday night backup) ?
Answer Question | September 28, 2012 1:12 AM
My current site uses a lot of custom menus, created via SDA. At present there is no way of knowing if the user’s environment is live, test, development or whatever and I’d like to use a message literal to provide a header line in the top row of all menus making the environment explicit. All…
Answer Question | September 27, 2012 7:04 PM
AS/400, iSeries, Menu, MSGID
Zebra 105sl is displaying Chinese (I assume) this morning. I’ve powered down, but to no avail. Any ideas how to work through the menu in chinese to reset to English?
Answer Question | September 26, 2012 1:32 PM
Zebra 105SL, Zebra printers
hi: i’m trying execute addjobscde inside a cl program. it run ok when scdday has an only day (*mon by example), when scdday has several days it reports an cpf0001. i’m using the below cl, and parameters’ values before the call are : – &nombre = ‘JSTJOLLOL’ – &lib = ‘ALMV20′ – &prog = ‘DCAB10B…
Answer Question | September 25, 2012 7:11 PM
We are trying to download a file through Client Access that has Simplified Chinese in fields that are defined as Open and CCSID 65535. The Chinese characters are coming through as ‘garbage’. Is there some setting(s) in the download that can be changed to accomplish this?
Answer Question | September 25, 2012 3:15 PM
Client Access, iSeries AS/400