• 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:
  • 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:
  • 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:
  • As400 files – a basic question from a newbie

    I know this is going to sound silly - a file has a format/formats. What is a 'member'?

    Raddy590 pointsBadges:
  • odbc data source

    odbc data source not displaying all dbs when pointing to sql2008. Only shows default db. odbc data source that points to sql2000 shows all dbs user has access to.

    Dowens20 pointsBadges:
  • Power builder 7.0 compatible with SQL 2005

    We currently use Powerbuilder 7.0 with SQL Server 2000. We want to upgrade to SQL Server 2005. Does anyone know if SQL Server 2005 is compatible with Powerbuilder 7.0?

    Mukulluniya305 pointsBadges:
  • Create XML file from AS/400

    How I do? How I send via ftp?

    JCCaballero5 pointsBadges:
  • Pros & cons to have a typical star schema but with only one fact value field and a thousand attribute names in one of the dimension tables?

    Want to build a kind of a scientific fact search and analytical engine for a lot of different types of measurements hosted in a lot of source tables and columns. A star join schema is built and data is copied (ETL) from the sources as usual - but all source column values are stored into a single...

    Rwg30 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