Are you using Gentran or GIS? Gentran NT doesn't allow real SQL statements. The "select" extended rule is not the same as a SQL select. Same with UPDATE. User exits are your only option in this case.
Other versions/platforms are outside my realm of expertise. Travis- -----Original Message----- From: soma SEKHAR BODDEDA [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 17, 2007 9:34 AM To: [email protected]; [EMAIL PROTECTED] Subject: [EDI-L] Reg:Using database tables in gentran Mapping Hi, I am doing an inbound Mapping, in which we need to get some data from database in the Begin of the Target Segment.I have written an select query at the start of the Target in Extended rule.i have created Table in my database even then i am getting an error while compiling such as ERROR "expected a database table name". can any one help in solving in error. Thanks Bye B.Somasekhar __________________________________________________________ Yahoo! India Answers: Share what you know. Learn something new http://in.answers.yahoo.com/ [Non-text portions of this message have been removed] ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix. Yahoo! Groups Links ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
