Originally posted by: SystemAdmin

i used excel sheet o convert into file. now i am using acess databse to retrieve the data and convert back to file format. My question wil be what will eb i am using command in input card..?
DBTYPE ODBC -SOURCE scf ..????
what all thing necessary to quesry against the acess table.? please reply me back if you have already done this
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

I use the Database Interface designer to create an mdq file for db connection. Input card uses commands such as -MDQ FoxPro.mdq -dbname lms -query jobtitle -t+
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

can u give some example please
ex:-MDQ FoxPro.mdq -dbname lms -query jobtitle -t+

what is LMS-QUERY jobtitle -t+ MEANS..?
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

can u give some example please
ex:-MDQ FoxPro.mdq -dbname lms -query jobtitle -t+

what is LMS-QUERY jobtitle -t+ MEANS..?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

it means you should read the manual. This will explain what the parameters are. It will also tell you the alternative to using an .mdq file.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender