• How do I fetch synonym names with the SQLTables function in ODBC API?

    Can somebody please explain how to fetch synonym names with the SQLTables function in ODBC API. I currently use the DSN created with SQL Native Client 10 and SQL Server 2005. My code is as follows:</p><p>ret = SQLTables(stmt, NULL, 0, NULL, 0, NULL, 0,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Way to speed up first invocation of stored procedure?

    Can you help? An iSeries user recently wrote the editors of Search400.com with this question: "One of our stored procedure takes approximately 1 minute for the first invocation when I do a call using RUNSQLSTM. If the same procedure is called repeatedly with different parameters, the results come...

    MichelleDavidson435 pointsBadges:
  • CHGPF command

    I am starting a project where I have to expand a field within a file and also add another field to the end of the same file. My question is this: I've never used the CHGPF command to change the file in the following situation. I've heard that you can use this command to create the new object and at...

    NJShoreBob0 pointsBadges:
  • Use of %Lookup BIF in Free form RPG – V5R3?

    Hi, I am having a problem when I try to use the %Lookup BIf in free form RPG. It doesn't seem to be functioning as it is supposed to. Is there something that I am missing (like PTFs) or is there a workaround to this problem if it is a previously known issue? Thanks for your help!!

    Adityavarma0 pointsBadges:
  • Owner ship change

    When would an ownership change appear? I know If you transfer owner ship authorities to other user . Is there any other way to change ownership.

    IVANRAO0 pointsBadges:
  • Database Splitting

    What other alternative do I have to split a lotus note database beside writing a code to copy  document to newly created database?

    mariolos5 pointsBadges:
  • EMAIL From MSAcess 2007 to Oulook/Exchange Server

    My mail email routine for sending emails with a .doc attachment work fine using MSAcess 2003 but don't work using MSAcess 2007

    Sea55 pointsBadges:
  • The IT Blog Top 10: Nov. 5, 2009

    10. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover has put together a useful tutorial for Sun’s xVM VirtualBox. 9. How to reset the Cisco Catalyst Switch to Factory Defaults Yasir Irfan offers some advice for those needing a fresh late on Catalyst switches. 8. Independent...

    Michael Morisy8,323 pointsBadges:
  • The most-watched IT questions this week: Nov. 3, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...

    Michael Morisy8,323 pointsBadges:
  • AS400 configuration management tools

    I am new to AS400 platform, and looking for a tool that will allow me to monitor configuration changes on multiple as400 servers and report daily on configuration changes per box and per aome sort of baseline. Any help will be greatly appreciated.

    AWHITSTON0 pointsBadges:
  • hi

    am trying to change audit for the user who are having *secadm authority CHGUSRAUD user(xxx) OBJAUD(*ALL) AUDLVL(*CMD) could you please help how to write CL for this. i have tried this PGM DCL &USER *CHAR 12 DCL &S *CHAR 2 DCLF FILE(xxxx/AIR) OVRPRTF FILE(QPSECUSR) HOLD(*YES) SAVE(*NO) PRTUSRPRF...

    IVANRAO0 pointsBadges:
  • db2/400

    Hi, on db2 hw to give the output query using webquery and consoal? And what is the meaning of webquery and consol?

    I6195 pointsBadges:
  • How to block AS/400 users from using WinSQL

    How can I block AS/400 users to modify data using WinSQL from the PC? Already I have some users that have insalled into their PCs iSeries Access and WinSQL, they run WinSQL that uses an ODBC to change data using SQL sentences. *** WinSQL is universal database management tool that can be used with...

    Maguito5 pointsBadges:
  • SQL Table Join when the name of a column in Table1 equals the value of a column in Table2

    Does anyone know how to write the SQL to join two DB2 tables when the name of Table1.columnA equals the data values stored in Table2.columnB? In the table structure examples listed below, I'm trying to figure out how to join Table1 and Table2 when the values in Table2.Tag_Name are equal to the...

    Bchat5 pointsBadges:
  • Printer Problems since relocation and client upgrade

    Printer will not start. Recently we moved a PC and a printer to a different desk and once everything was hooked back up we can't get the AS/400 to recognize the printer. I get a message that states: Device PAMPRT1 not available. The status is 'Vary on pending'. The spool writer, labeled P9 shows...

    EventHorizon0 pointsBadges:
  • Equivalent of a Application MAKE file on AS400

    I am trying to port a C App from windows to AS400 as well. I used FTP to get the Code and App specific header files. But when it comes to compiling the code I have road blocks as functions defined in a C program is used in another C program and its all dependent on each other and their is no entry...

    Rekhap0 pointsBadges:
  • DB2 UDB for iSeries: Using CPYTOIMPF to trim blanks

    Mark is looking for an alternative to trimming blanks from the end of a record. He writes: "I would like to use the CPYTOIMPF command only if I can Trim Blanks from end of Record. I found out how to do this in FTP, but would really like to stay on this path and avoid FTP using Override Inputs. I...

    MichelleDavidson435 pointsBadges:
  • CPYTOPCD filename length limitation

    Hi all, Am aware of the limitation of the filename (filename.ext) for CPYTOPCD command. eg: 12345678.123 (8chars and ext 3chars). Is there any command that I could use to have my filename as follows: AA12345678.txt or AA12345678 ? Or maybe additional step that I could insert into my CL after the...

    JechLee5 pointsBadges:
  • QMF issue

    I have my QMF for windows version 8.1 Fix Pack 13, and I try to run this instruction INSERT INTO destination table SELECT * FROM origin table and every time I receive this error message: An error occurred while running the query. destrination table not valid for operation. (SQL code = -7008, SQL...

    Tiburonblanco80 pointsBadges:
  • Changing DB2 Short or Internal Names

    We never drop and recreate tables in production. We do regularly in test. Recently we used the ALTER statement to remove a column in a table. The internal or short name was obviously MAX_P00001 because now we only have a MAX_P00002 and a MAX_P00003(using DSPFFD). In test, the table has MAX_P00001...

    RodVerity20 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