Prev
Next
Forums User Experience Lawson Design Studio

Non Lawson table access by DS

 6 Replies
 0 Subscribed to this topic
 12 Subscribed to this forum
Sort:
Author
Messages
ryan
Veteran Member
Posts: 51
Veteran Member
4/22/2009 8:16 PM

     Is it possible to use a Crystal report, .csv file to use as a data source 

    in Design Studio?

    Can a non-Lawson table be created and set up with dbdef and access it with DS? Possibly need to do a blddbdict or bldora10ddl.

     

    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
    4/22/2009 8:24 PM
      You can access a non-Lawson table if it's defined in Lawson but not a CSV file.
      David Williams
      Ben Coonfield
      Veteran Member
      Posts: 146
      Veteran Member
      4/22/2009 8:42 PM
        It would be tricky to set up, but if you are using Oracle, you might be able to use a .csv as a DS data source by defining what Oracle calls an External table. An external table looks like a regular table as far as SQL select calls are concerned, but the data is not stored in the database. Instead, every time you do a SELECT then Oracle reads a flat file -- which could be a .csv. I have used an external table which was definied somethink like this:

        CREATE TABLE LAWSON.ZZINV
        ( "P_TYPE" CHAR(3 BYTE),
        "C01" VARCHAR2(12 BYTE),
        "C02" VARCHAR2(22 BYTE), )
        ORGANIZATION EXTERNAL
        ( TYPE ORACLE_LOADER
        DEFAULT DIRECTORY "AP_INPUT"
        ACCESS PARAMETERS
        ( RECORDS DELIMITED BY 0X'0D'
        badfile AP_OUTPUT:'invoices.dat.bad'
        logfile AP_OUTPUT:'invoices.dat.log'
        FIELDS TERMINATED BY '|'
        LRTRIM
        MISSING FIELD VALUES ARE NULL
        REJECT ROWS WITH ALL NULL FIELDS
        )
        LOCATION ( 'invoices.dat' )
        )
        REJECT LIMIT UNLIMITED;
        ryan
        Veteran Member
        Posts: 51
        Veteran Member
        4/22/2009 8:58 PM

          When i attempt to build against the created table i get this error mssg:

          PROD=TEST&FILE=HREMPPDO&INDEX=PDOSET1&FIELD=EMPLOYEE;CHECKDATE;ACCRUALRATE;ELIGBALANCE&SELECT=EMPLOYEE=100123&OUT=CSV&DELIM=~

          at com.lawson.ios.dig.db.DigObject.getDbFile(DigObject.java:698)

          at com.lawson.ios.dig.db.DigObject.executeInternalRequest(DigObject.java:234)

          at com.lawson.ios.dig.db.DigObject.executeRequest(DigObject.java:173)

          at com.lawson.ios.dig.db.Dme.executeRequest(Dme.java:74)

          at com.lawson.ios.dig.ErpDmeAgent.processRequest(ErpDmeAgent.java:111)

          at com.lawson.ios.agent.container.AgentContainerImpl$AgentWrapper.processRequest(AgentContainerImpl.java:467)

          at com.lawson.ios.dig.DmeBroker.processRequest(DmeBroker.java:59)

          at com.lawson.ios.agent.container.AgentContainerImpl$AgentWrapper.processRequest(AgentContainerImpl.java:467)

          at com.lawson.ios.agent.container.AgentContainerImpl.processRequest(AgentContainerImpl.java:239)

          at com.lawson.ios.servlet.Router.doGet(Router.java:214)

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

          at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:995)

          at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:930)

          at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)

          at com.lawson.servlet.TransformFilter.doFilter(TransformFilter.java:126)

          at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)

          at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)

          at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)

          at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:761)

          at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:673)

          at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:498)

          at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)

          at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)

          at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744)

          at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1455)

          at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:113)

          at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)

          at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)

          at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:263)

          at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)

          at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)

          at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

          at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

          at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

          at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)

          at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)

          at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)

          at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)

          at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)

          ]]>

          John Henley
          Posts: 3353
          4/22/2009 11:04 PM
            Does rngdbdump work for the server?
            Thanks for using the LawsonGuru.com forums!
            John
            Gary Davies
            Veteran Member
            Posts: 248
            Veteran Member
            4/23/2009 9:36 AM
              Another possibility is to put the file in the persistdata directory and use the FileMgr servlet to read it in Design Studio.
              ryan
              Veteran Member
              Posts: 51
              Veteran Member
              5/22/2009 1:39 PM

                We ended up working out this solution: DBA setup a view from a csv file that is refreshed nightly and I created a portal page based off the new table.  Thanks for your suggestions