parametersetlgraphical-programmingab-initio

"m_db unload" command not returning any value in AbInitio

I am using m_db command to load the value from a table to a parameter in AbInitio graph.

But its not showing any value. I also run it in Unix but still its not showing any value.

The command is (enclosed in back ticks):

`m_db unload myoracle.dbc - select "select name from employee"`
Solution

  • I have found a solution for this problem. There were two mistakes I was doing:

    First I was not committing the data after insertion in SQL server.

    Second I was using parameter interpretation as substitution but now I have changed it to shell.

    Any other suggestion are most welcomed. :)