IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

help JDBC Adapter service to write in flatfile

  • 1.  help JDBC Adapter service to write in flatfile

    Posted Tue July 27, 2010 01:20 PM

    set pagesize 0
    set closep |
    spool /tmp/df_order_forecast.dat
    select * from cdrmgr.forecast_orders;
    spool off

    the above query, pick the data from tables and write flat file separateded by ‘|’ and write file in /tmp/ directory

    in SQL developer it is working fine , i want to do in JDBC Adapter, which adapter service will full fill above requirement, do i need to go for adapter service or stored procedure, i have tried with customSQL adapter service but i didnot acieve this.

    am using oracle database and webMethods 7.x

    Regards,
    anil kumar ellendula


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


Related Content