ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Running SQL command in Green Screen vs Navigator

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Running SQL command in Green Screen vs Navigator

    I wrote a simple update command:
    update whatever set field='11' where whaterver

    Now, field is 5 chars long. In iSeries Navigator that statement worked fine. in AS400 Green Screen, I had to do this:

    update whatever set field='11 ' where whaterver

    I had to add the spaces in front to make it 5 chars long...

    Any settings in AS400 Green Screen to say...ignore the spaces? wonder why iSeries Navigator worked...

  • #2
    Re: Running SQL command in Green Screen vs Navigator

    Try using the navigtor to run you update then look at the file on the green screen to make sure it is what you expected. Did you use navigator to verify your results for the green screen?

    just curious.
    Hunting down the future ms. Ex DeadManWalks. *certain restrictions apply

    Comment

    Working...
    X