• WRKJOBSCDE every *other* week

    Does anyone know how to use the IBM scheduler to submit something every *other* week or every third week, etc? Thanks, Kevin

    TylerDurden0 pointsBadges:
  • SNDDST TYPE(*DOC) not working for big files

    We are using SNDDST to send reports via internet e-mail. It works for small reports (text files) but not for larger ones. No error is shown when issuing the command. QSYS/SNDDST TYPE(*DOC) + TOINTNET((sbchenry@hotmail.com *PRI)) + DSTD('Sending a Text') + MSG('Find the report attached.')+...

    SBCHenry30 pointsBadges:
  • Stored Procedures on AS/400

    Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks...

    Ashnirody100 pointsBadges:
  • Retrieval of Extended Source Library Information

    Is there a way via FTP to retrieve additional source code line-level details (sequence #, date line of code was changed) from iSeries RPG/CL source libraries? If not via FTP, is there another way to extract and transfer this information?

    Rchapin0 pointsBadges:
  • Help with converting Mainframe file on iSeries

    Hi there, I'm looking for some advice/help on a file that I'm having some trouble with. The file originates from a mainframe, and is sent over to our iSeries (V5R2M0) via Connect:Direct. The file is 3680 Bytes long, comprising of string and compressed numeric data. I have the layout of the file,...

    Nealhudson0 pointsBadges:
  • AS400 name not resolving in DNS

    On Sunday I restarted my AS400 prior to doing my monthly full system back up. When it came on line, none of my PC's could resolve the system name (s10a####) to the internal ip address. I entered a DNS entry manually on my internal Windows 2003 DNS server, and all the PC's running XP pro can connect...

    Sidzilla0 pointsBadges:
  • The IT Blog Top 10: Dec. 10, 2009

    10. No Exchange 2007 on Windows 2008 R2 – but why? Brendan Cournoyer delves into why the latest Windows 2008 R2 takes a surprising turn in not support Exchange 2007. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8....

    ITKE1,072,415 pointsBadges:
  • Encrypt Data using BRMS

    Hi, How do I Encrypt Data using BRMS in iSeries? What are the steps and also let me know if any additional License or Device is required. Till date we have been using BRMS only to Backup Spool Files, but now we are in the Process of Migrating our Daily & Weekly Backups from ordinary SAVLIB Command...

    Haaiderali215 pointsBadges:
  • Where is the source file of an ILE program?

    Hi,  I need to find out the name of the source file of a ILE program. I am getting a blank using DSPOBJD. I know it can be rtrieved using dsppgm but I need to run the process in a program and strore the output in a file.  Pls help... !! This is kinda urgent...  Thanks,  Ankita...

    Ankita135 pointsBadges:
  • The most-watched IT questions this week: Dec. 1, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. CompEng asked about open-ended SQL statements, and Mrdenny and Meandyou delivered the goods. 2. Kalpana queried Networking certifications, and where the best place is to get...

    Michael Morisy8,643 pointsBadges:
  • rpgle programming

    when i call my rpg program the display screen is not exiting though i have added CF03 function in the DDS of the display file,or is something wrong with my program and here is the rpgle code to get the date for a particular id.. ******************************************************** FDSPF  CF...

    Peraj55 pointsBadges:
  • Is this possible

    I am writing a cl that will run two seperate queries. the first builds a file. the second needs a parameter before it can be displayed. The parameter is a route range. We get the route from a production file. Is there away to do a read or a chain statement to a file that will allow me to get that...

    Cowboypgmr0 pointsBadges:
  • My AS400 to Excel VBA works on my pc but not my boss’s

    Hi I created a VBA Excel program to get data from our AS/400 It works on my pc but not my boss's. It says 'connection failed' He has Client Access installed. What would he be missing? It seems like from the connection string below that he would need Client Access Driver but isn't that automatically...

    Colmbyrne0 pointsBadges:
  • Displaying Chinese on 5250 screens

    Hello, I need to change some CL driven green-screen menus to display Chinese instead of English. We don't need to change the applications or data behind the menus ... just the menus themselves which are actually driven by message files with a display file and some CLP. Does anyone know of a...

    Oldgrayprogrammer0 pointsBadges:
  • SQLCOD = -7008 when doing an insert into file using SQLRPGLE-2

    Hi, I'm trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am...

    SasiKumar0 pointsBadges:
  • fsk verses cpfsk

    I'm familiar with what FSK (frequency-shift keying) is, but I've recently heard a term tossed around sometimes interchangeably with FSK, sometimes not, called CPFSK (continuous phase frequency-shift keying). Could you tell me what is the difference? Is CPFSK just the assurance that the phase of the...

    Terrry5 pointsBadges:
  • How to Trace and ODBC job Identity

    how to find by whom the JOB has been submitted through ODBC connection?

    Websphere50 pointsBadges:
  • commitment control and activation grp in ILE

    I am new to AS/400, can you a link or resource that talks about commitment contrl and activation group briefly.

    Sugaar0 pointsBadges:
  • How to determine the AS/400 is completely recovered?

    Hi, we are running a Disaster Recovery test and for auditing purposes, we need to hav a log which says the system is completely recovered to the date of DR. We do have all the history logs but as mentioned is there a way to show the proof as such with a screen or completion message?Thanks in...

    harisudhan211,005 pointsBadges:
  • iseries system management monitor

    Hi, I'm looking for a iseries system management monitor tool. I found one at www.tango04.com, Visual Message Center, but my question is; are there other alternatives available? These monitors can run on Windows or Linux platform, a gui would be nice.

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

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