CL Program Questions and Answers

Recent IT Questions

1 - 14 of 14
<<PREVIOUS 1 NEXT>>

AS400 - FTP (put & get) files size compare.

Hi, i have created a ftp scritp to put & get (back trasferred file) then compare them using CL program. ie: FTP Script PUT FROM_LIBRARY/FROM_FILE TO_LIBRARY/TO_FILE GET FROM_LIBRARY/FROM_FILE QTEMP/TO_FILE CL pgm 1) RTVMBRD FILE(FROM_LIBRARY/FROM_FILE) NBRCURRCD(&NBRCURRCD) ...

View Answer   |  Jul 31 2009  10:31 PM GMT
FTP Script, CL Program, AS/400 FTP
asked by H0S400

  10 pts.

Controlling JDE app outage times during CL reorg

We currently run a weekly reorg controlled by a CL program. Until recently we had a four hour window and are now looking to do the reorgs with the smallest possible JDE application outage. Any recommendations?

View Answer   |  Jul 29 2009  9:01 PM GMT
AS/400 backup, JDE application outage, CL Program
asked by AS400 - Ask the Expert

  395 pts.

how to pass numeric data to cl program from as400 command line

Hi All, I want to pass numeric data of length (8 0) to my CL program while calling from AS400 command line but program is not receiving correct value into the program. Can anyone plz help me how to pass numeric data.

View Answer   |  Jun 24 2009  1:18 PM GMT
AS/400 Command Line, AS/400 command keys, CL Program
asked by Mohan K

  465 pts.

Run SEQUEL Viewpoint Client Report from CL

How can you run a Viewpoing client report from a batch CL job?

View Answer   |  Jun 18 2009  6:02 PM GMT
SEQUEL, Viewpoint, CL
asked by SamH

  5 pts.

Create a Stored Procedure using CL and RPGLE programs

I have an RPGLE program called from a CL program for database files overrides. I want to call the same programs from a stored prodecure on SQL Server from within a Web application. I am brand new to SQL Server but am pretty good on the AS400.

View Answer   |  Jun 12 2009  3:17 PM GMT
RPGLE, CL, Stored Procedures
asked by NCharette

  5 pts.

Transact SQL stored executed from AS/400 CL program.

How can I execute a Transact SQL stored procedure (actually in the database) on a SQL 2000 database from an AS/400 CL program.

View Answer   |  Jun 8 2009  2:39 PM GMT
SQL Server 2000, AS/400, SQL Database
asked by Jcorzine

  20 pts.

Query Run

A query is running in CL program and it is not showing any error and still it is running for hours together, how to find what error is there in the query?

View Answer   |  Jun 2 2009  3:45 PM GMT
CL Program, CL Queries
asked by PS2112

  30 pts.

Program Change

We have legacy software when a user sign's on it takes them to a CL program/menu. If I make a change to a program they have to sign off and back on to ge the new change. Is there anyway to force that change to that user without them signiong off? There has to be away to do this. Thanks

View Answer   |  Jun 2 2009  1:20 PM GMT
AS/400, CL Program
asked by RonKoontz

  1310 pts.

self-submitting cl pgm doesn't release screen

The interactive code in the CL pgm calls an RPG subfile pgm. The user makes selection, the CL pgm steps to the SBMJOB command, the CL pgm is executing the Batch portion, but the screen is hung up with "X system" displayed until batch job is done. The RPG is turning "ON" *inlr and RETURN is...

View Answer   |  May 29 2009  2:22 PM GMT
CL Program, CL
asked by Mccsteven

  30 pts.

strsql

can you use the strsql command within an AS400 cl program?

View Answer   |  May 13 2009  2:37 PM GMT
STRSQL, CL, CL Program
asked by Pb54

  10 pts.

WRKLNK on iSeries - HOW CAN I LIST THE STMF FILES UNDER A DIRECTORY

How can I list or retrieve in a cl program the STMF files under a specific directory? Urgent reply requested. I am running a cl program that run use a software package that runs decryption on a group of stmf data with variable name. I need to retrieve the names in my cl to do further...

View Answer   |  Apr 9 2009  5:18 PM GMT
CL Program, WRKLNK, STMF
asked by Ann

  45 pts.

MONITOR FOR HELD LOCKS

I created this pgm to check if a file is being locked. I would like to trap if there is a hold lock. If I can I would like to loop back if there is a hold until the hold is released. WRKOBJLCK OBJ(MCPARMS) OBJTYPE(*FILE) ...

View Answer   |  Feb 18 2009  4:40 PM GMT
CL Program, WRKOBJLCK, CL programming
asked by Vince01

  25 pts.

Auto download a .CSV file from network drive

to a AS/400 physical file through a cl program? how can I do this?

View Answer   |  Feb 12 2009  6:09 PM GMT
Physical File, CL Program, CSV
asked by UARTJ

  5 pts.

CL Program

My management has ask me to disable the ability of users to access to command line access from an application by limting capabilities *YES. I need to write a CL that will allow me to place RUNQRY into the application menu and need help creating the CL program. Can anyone assist?

View Answer   |  Oct 16 2008  5:18 PM GMT
CL, CL Program
asked by Chardyjr

  45 pts.

1 - 14 of 14
<<PREVIOUS 1 NEXT>>