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

    GHENDER215 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:
  • 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:
  • Accessing an Access DB from Outlook via VBA

    Hi The situation: In Outlook I get a message from a server. The content of the message needs to be put into an Access db. But, there may not exist another message with the same date. So, I need to look into a db if there is already a message with the same date and time. If there exists one, then it...

    Camastanta50 pointsBadges:
  • Oracle 10G installation errors on memory variable

    WHEN I INSTALL ORACLE 10G FIRST TWO THREE TIMES INSTALLED PROPERLY.AFTER DELETING ALL THIRD TIME AFTER INSTALLING DEVELOPER SUIT I DELETED 10G AND INSTALLED AGAIN.AT THAT TIME ENVIRONMENT VARIABLE 1036 ERROR MESSAGE CAME .   HOW TO OVERCOME THIS ERROR  

    PAPA1015 pointsBadges:
  • TAB to skip field – SYNON

    I have a synon screen pgm with 5 input fields - one below another. I am on first field, and on pressing TAB there, I want the cursor to go to third field skipping the second. How can I do that? Plz help.

    Rituraj0 pointsBadges:
  • JAVA classpath

    Open Source team coded a series of Java .jar apps that I have placed in IFS in root/JAVA_HOME folder. I need guidance on how to create a CLASSPATH to the IFS folder so my CLP can call the JAVA app.   Do I define the CLASSPATH in the CLP or set up WRKENVVAR? Is there a better solution for placing...

    Droutt75 pointsBadges:
  • Copy Registry key using VBS Script

    Hi, I have a question i'm trying to copy the PC name witch is located in (HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlComputerNameComputerName)  to a different registry key (HKEY_LOCAL_MACHINESOFTWAREIOLANSphereStation) but i can't get it to work. I thought is should work with the script...

    Digital825 pointsBadges:
  • Source highlighting using NetManage Rumba

    Has anyone developed a keyboard macro, VB Script or WSCST object that will let you enter the hex values necessary to highlight source code in SEU while using Rumba? I found a few examples for CA/400, but not for Rumba. TIA...Chuck

    ChuckM0 pointsBadges:
  • RPG Program in MSGW status blocks Java Application

    Hello. I'm looking for the best way to identifying when a RPG program called from java is waiting for a message response (MSGW status). When this situation ocurrs, my java application waits for the RPG execution returns, indefinitely.

    Mariodlg2,790 pointsBadges:
  • Physical file over 600 000 000 records

    Hi We have a Physical file which has more than 60 million records in it. In our application we search for the particular records based on 6 fields as a search criteria (web based) , search process are done in SQL Procedures. Even when i creatd a LF based on the mandatory search fields , we get  a...

    As400programm10 pointsBadges:
  • clear physical file member question

    is it possible for me to only clear certain records of a physical while leaving certain records available? I have a file with thousands of records, but I only need the records starting with a certain date. How can I delete everything prior to the date that i need with out totally wiping out the...

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

Following