• Odd problem (conversion or openquery?) only appearing in a stored procedure but not when running it adhoc

    Here's the code I can run with no problems: declare @AnneeSelectionnee numeric select @AnneeSelectionnee = 2009 declare @DateDernierImport datetime select @DateDernierImport =  'Nov 14 2008 12:00AM' SELECT     LTRIM(RTRIM(T_ASFSTAG0.STANS1)),     LTRIM(RTRIM(T_ASFSTAG0.STHFO1)),...

    LeftForDead20 pointsBadges:
  • Journaling and Commitment Control

    If I have journaled a file with After Update parameter, how will the commit/rollback work??

    Reenasudarshan65 pointsBadges:
  • CRTUSRPRF

    Could you please some one help me to create userprofile.

    VENKYAS40075 pointsBadges:
  • Remote access to QCTL Console

    How can we connect or work with console remotely?

    qmaster1,675 pointsBadges:
  • Activity Levels in AS/400

    What are the Activity Levels in AS/400 Subsystem? How can we take control over the activity levels?

    qmaster1,675 pointsBadges:
  • what is the diffrence beetween v5r3 and v5r4 ?

    what is the diffrence beetween v5r3 and v5r4 ? Could some one list it down for me?

    harisudhan211,005 pointsBadges:
  • RPG/400 Error RNQ1255

    I have a RPGILE (XOP560) program. I am able to compile sucessfully this program. once i call this program i am getting below error. please advice me. Additional Message Information Message ID . . . . . . : RNQ1255 Severity . . . . . . . : 99 Message type . . . . . : Inquiry Date sent . . . . . . :...

    Askt265 pointsBadges:
  • How do I call an API which is in a service program

    I hope somebody can shed some light on the following. I need to call an API "QjoRtvJrnReceiverInformation" which is in service program QJOURNAL. I am not new to ILE but experience of using service programs and using API's within service programs is limited Do I need to code all the 'D' specs and...

    Djb20 pointsBadges:
  • STRSDA

    How do I create standalone fields in SDA,ie fields not coming from a file

    STCA60 pointsBadges:
  • The most-watched IT questions this week: Sept. 15, 2009

    As part of a new feature on the IT Knowledge Exchange Community Blog, we're highlighting the top 10 most-watched questions. Here are the top 5: Virtualization vs. ConsolidationTracing a computer to an IP addressConnect remote Oracle 11g server in VB 6.0How to utlize multiple static IP's when ISP...

    Michael Morisy8,588 pointsBadges:
  • AS400 – DB2 file names

    Given a view name, how will i find its physical file name... e.g. my view name is EMP_TMP_TPL_HDR Thanks, NG

    Nutangujar895 pointsBadges:
  • AS400: copybook or module? …or…other?

    I'm on V6R1, using WDSCi 7 to program in RPG IV.  I've accumulated a number of functions that I use in quite a few of my programs, and I was thinking it might be a good idea to go ahead and place them as subroutines (may be wrong terminology) in a copybook.  But, having done some research, there...

    Koohiisan5,045 pointsBadges:
  • AS/400 User Profile Creation Date & Time

    We can find the user profile creation date and time as, WRKOBJ OBJ(QSYS/USRPRF) OBJTYPE(*USRPRF) Is the anyother way to find it?

    Lsivabe85 pointsBadges:
  • DST AND SST

    What are the significant differences between SST and DST?

    qmaster1,675 pointsBadges:
  • File open RPG

    Is there a way in an rpg program to open a file using a character field for the filename? for example: if my file name is TESTFILE I can use the line: (in rpg free)   OPEN TESTFILE; but is there a way to have character field in place of the filename:   D filename          ...

    Srikant5 pointsBadges:
  • AS/400 RLU

    I need to declare a character field in Report with length of 280. But when given the length greater than 249, it throws the error message as "Field deleted by changes. Press Enter to confirm. " Is there any way to declare a Field of length greater than 249 in RLU.

    Maheshero40 pointsBadges:
  • Use of Alternate Table/Array Name?

    Whats the use of use of Alternate Table/Array Name when defining a table/array in E Spec?

    Kar425 pointsBadges:
  • E1 supporting RF device

    Sir , I have to install a point to point  RF link between 2 location wiht the capactiy of   E1 or  2E1 . so cud u pls cuggest me what are the best products to install a point to point   E1 or  2E1 or 100 Mps capacity for IP Network . Thank  you Teh student.

    Ksr1234320 pointsBadges:
  • copy spool file to another user’s spool file

    hi, any command allowed me to copy printer file in my spool file to another user's id spool file. thanks.

    Boulevard55 pointsBadges:
  • As400 – XML

    Can i pass value from DB2 400 to XML.. how to do this?

    Nutangujar895 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