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

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.

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…

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)…

Can i use single cursor for multiple SQL statements? ex:  declare c1 cursor for select * from ……. also declare c1 cursor for select * from xxx

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…

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…

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…

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

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?

How to move tapes from I/O slot to storage slot via BRMS

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?

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

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…

How do I move a tape drive between 2 LPAR’s without having to do it manually?

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) ?

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…

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?

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…

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?