Jump to content
Changes to the Jaspersoft community edition download ×

as400 help please


tlavalle

Recommended Posts

I need some help from someone who is knowledgable with the as400. I have my driver and url correct and working. the problem i am coming to is that the field names have @ in front of them, Also when i compile i either get delete tokens or a bunch of errors. How can I use the the field names with the @ in front or if not what is my best option.

 

thank you in advanced

Tony

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

DOH!! I forgot you can do that. It seems to work except now i get SQL Problems:[sql0206]Column hdia1 not in specified tables

 

 

here is my sql statement

select h.@henc# as henc, h.@hdia1 as hdia1, h.@hdia2 as hdia2

from pfcfilso.@enchdr h

where hdia1 = '27447'

or hdia2 = '27447'

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...