• Is it possible to reorganize a very big transaction in one night?

    I want to reorganize a very big transaction file in day end process and it cannot finish within 1 night. The problem is RGZPFM command lock that file ,so the day after , user cannot use that file because it is locked. Do you have any ideas to help me?

    Cookiekitty110 pointsBadges:
  • create computations on the fly

    We are primarily a COBOL shop. We have some COBOL ILE and some RPG. I have a need to replicate a function on the I-series that is currently done in Excel. This function allows them to create formulas on the fly to arrive at pricing information. I can work through issues with interactive maintenance...

    Roses060 pointsBadges:
  • 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...

    Hmonat20 pointsBadges:
  • Using RPG constants in Static Embedded SQL

    I have tried to use an RPG IV constant (D-Spec with a "C" usage and value) in embedded, static SQL as a host variable and the compiler fails. I was told this was possible, but so far I do not know how to do this. Not surprisingly, IBM documentation is practically worthless in trying to find out the...

    Mscottx0 pointsBadges:
  • Blocking certain fields from being downloaded using Client Access

    Hi, By using WRKQRY, we can select the files and create output files. My problem is how do I block certain users from downloading certain sensitive fields like Price in the output file. Thanks..

    N4t45h40 pointsBadges:
  • RLU Document

    Hi I have been working with program described printer files till now. But I would have to start working on externally described printer files. I know we can use RLU to design externally described printer files but I do not know how to use RLU. Can anyone please point me to any document on how to...

    Pgsdeb20 pointsBadges:
  • Cataloging Stored Procedures

    Need to know if anyone has a package or process to do the actual storing of information around a Stored Procedure? My area is being tasked with becoming the Librian for all of our stored procedures whether created with true Sequel or RGP with imbedded SQL. I am looking for a way out side of say our...

    ATHMAU0 pointsBadges:
  • SYNON vs COBOL

    Hi All, This query is related to performance. I am currently in the process of changing an application from COBOL to Synon. The application uses a lot of I/O involving files. Upon converting the application to Synon, I find that the performance has declined - COBOL takes 8 minutes whereas Synon is...

    Rituraj0 pointsBadges:
  • MONMSG and SNDRPY

    Dear, I'm trying to write a small program to run my backup job via BRMS... and I would like to check the different errors and reply automatically to few of them. Ok, I can monitor the error messages through MONMSG but how can I reply to them ? I know that I have to use SNDRPY but how can I have the...

    PierreLG45 pointsBadges:
  • FTP from Client site

    I am trying to receive data from a client site into an externally described file on my ISerie. Data will be received daily and the file name is date stamped, (for example:filea103106, filea110106)my problem is that since it needs to be copied into MYLIB/MYFILE, I cannot use the MGET filea* to copy...

    Hmonat20 pointsBadges:
  • Optical storage

    I am trying to copy database files from the iSeries to a DVD (optical storage) and would like the files on the DVD created in ASCII text format. Similar to a data transfer from the iSeries, you can specify the file type ASCII text. The database files are actually spooled files that were copied to...

    Rick1020060 pointsBadges:
  • Running a job in SQL 2005 by calling a batch file from a As400 CL program

    Hi, I already asked this question before but did not get any reply. Anybody please help.. I am calling a job on AS400 which uses RUNRMTCMD to execute a batch file on sqlserver 2005 server. This batch file uses sqlcmd command to run a job on sqlserver. When I execute this batch file manually from...

    Gullu15 pointsBadges:
  • Array Corruption

    I have written an RPGLE pgm in which I took an array with a size of 400 (20 fields with a length of 20) and did a MOVEA to put it inside a character field of 400. I then passed this field to another program and I did a MOVEA to populate the array in the 2nd program. When I call the 2nd program...

    GHENDER190 pointsBadges:
  • Using API : unlink()

    Hello All, Is anyone aware of "authorities" issues related to this API? I am creating .PDF files in the IFS area of our iSeries box and some users are unable to recreate a .PDF if they did not create it. In an attempt to avoid this I would like to use this API to "unlink" or "delete" this IFS...

    Mrs9693nj0 pointsBadges:
  • website on iSeries not being indexed by web search engines

    Our website is hosted on our iSeries.  It appears that our pages are not being indexed by the various web search engines.  Has anyone encountered this?  Any ideas on where to look/what to check?  We are using our ip address not a DNS name.  All pages are encrypted (https). 

    Chance105 pointsBadges:
  • Pipe Delimited CSV File

    I have the following Pipe Delimited data in a physical file: Dealer Name¦Deal Number¦Buy/Sell¦ Joseph Camm¦80740¦S¦IG¦5000000.00¦ After issueing a CPYTOPCD command, I end up with: Dealer NameÝDeal NumberÝBuy/SellÝIG1ÝAMOUNT_amountÝ David CammÝ80740ÝSÝIGÝ5000000.00Ý How do I get...

    Ricca100 pointsBadges:
  • How can I use a variable in my macro to import data from as-400 to excel?

    I import data from our as-400 to an excel spreadsheet to do further analysis.  One of my criteria is the customer number and that is what I would like to be a variable. Hence under the vba that retrieve the info, that criteria now read like this   "WHERE (ORDDET01.CUSN='3559')" When i tried to...

    Yves69520 pointsBadges:
  • Tab delimited file

    I have been asked to produce a file in an RPG program. The file is being used in some kind of interface and needs to be 'tab delimited' What is tab delimited? How do I create a tab-delimited file? Thanks

    Raddy590 pointsBadges:
  • Will Visual Studio 2003 and SQL Server 2008

    Will Visual Studio 2003 work with SQL Server 2008 databases.

    CGarnett15 pointsBadges:
  • Send a program completion message to a user

    A user call an update program - which will complete in a nanosecons as it reads 1 record and updates it. How Can I send a message to the user from the pgm giving completion data? Program could be CL or RPG3/4

    Raddy590 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following