×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Job code Change Report help

Job code Change Report help

Job code Change Report help

(OP)
I built a job code change report in Reportsmith that is supposed to return from and to dates for each job code. My 2 sql criteria statements test out fine, and my 2 derived fields test out fine, but when I hit done all I get in return is ORA-00933:SQL command not properly ended. I am not a programmer, so I don't even know where to start looking for how to fix this error. Can anyone help me?

RE: Job code Change Report help

Could be an ODBC driver error. If you can try connecting to Oracle without using ODBC.

John Sakalauskas
VantageIS,LLC

RE: Job code Change Report help

I have had this problem before.

You said you are using SQL statements.  I assume these are derived fields.  Put () around the whole derived field.  Next, put a space in front of each line of the SQL - should look like this:

(SELECT P.EMPLID
 FROM PS_PERSONAL_DATA P, PS_JOB J
 WHERE (( (TO_CHAR(J.EFFDT, 'YYYYMMDD') || J.EFFSEQ = (
           SELECT MAX(TO_CHAR(i.EFFDT, 'YYYYMMDD') || i.EFFSEQ)
           FROM PS_JOB i
           WHERE i.EMPLID = J.EMPLID
             AND i.EMPL_RCD_NBR = J.EMPL_RCD_NBR
             AND i.EFFDT <= SYSDATE)) AND
          (J.EMPL_STATUS IN ('A', 'L', 'S')) ))
)

Notice () around the whole SQL derive field and the space in front of the 2nd and 3rd rows.

Hope that helps.

RSGeek at WI dot RR dot COM
  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close