Skip to main content

Anyone else using ACU Cobol with MS SQL

  • September 9, 2011
  • 11 replies
  • 0 views
D

[Migrated content. Thread originally posted on 08 September 2011]

Just curious, is anyone else using Acu Cobol with MS Sql?

Thanks

Woody

    11 replies

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • September 9, 2011

    [Migrated content. Thread originally posted on 08 September 2011]

    Just curious, is anyone else using Acu Cobol with MS Sql?

    Thanks

    Woody
    We are, but only in a couple of programs. We'd use it more, but it's limited by the problem that you can't re-use a cursor if you want to run a second query.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • September 12, 2011

    [Migrated content. Thread originally posted on 08 September 2011]

    Just curious, is anyone else using Acu Cobol with MS Sql?

    Thanks

    Woody
    im not using esql. i guess you could say dynamic sql. I build a valid sql query, prepare an object from the query text string and then declare a cursor based on the object that was generated from the query text.

    the code works great but i have questions.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • September 12, 2011

    [Migrated content. Thread originally posted on 08 September 2011]

    Just curious, is anyone else using Acu Cobol with MS Sql?

    Thanks

    Woody
    im not using esql. i guess you could say dynamic sql. I build a valid sql query, prepare an object from the query text string and then declare a cursor based on the object that was generated from the query text.

    the code works great but i have questions.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • September 14, 2011

    [Migrated content. Thread originally posted on 08 September 2011]

    Just curious, is anyone else using Acu Cobol with MS Sql?

    Thanks

    Woody
    What questions do you have? My experience with it is kind of limited, but there might be someone else on the forum who knows the answers.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • September 15, 2011

    [Migrated content. Thread originally posted on 08 September 2011]

    Just curious, is anyone else using Acu Cobol with MS Sql?

    Thanks

    Woody
    Has anyone else experienced a slight delay when the program is issueing the call to sql? I can run the query from the sql query analyzer and it retrns fast, no delay but when run from acucobol there is a slight delay and then its going.. this happens with every time the program invokes sql.

    other than that im pretty happy with how its working.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • September 20, 2011

    [Migrated content. Thread originally posted on 08 September 2011]

    Just curious, is anyone else using Acu Cobol with MS Sql?

    Thanks

    Woody
    Can't say that I've noticed any delay. We're just pleased with the speed at which we can get certain tasks done, compared to doing the same thing reading records from a vision file.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • September 20, 2011

    [Migrated content. Thread originally posted on 08 September 2011]

    Just curious, is anyone else using Acu Cobol with MS Sql?

    Thanks

    Woody
    Can't say that I've noticed any delay. We're just pleased with the speed at which we can get certain tasks done, compared to doing the same thing reading records from a vision file.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • September 21, 2011

    [Migrated content. Thread originally posted on 08 September 2011]

    Just curious, is anyone else using Acu Cobol with MS Sql?

    Thanks

    Woody
    lol yes. if the process can be designed to be handled at the server its quick!
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • September 24, 2011

    [Migrated content. Thread originally posted on 08 September 2011]

    Just curious, is anyone else using Acu Cobol with MS Sql?

    Thanks

    Woody
    are you using embedded sql or dynamic sql?
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • September 27, 2011

    [Migrated content. Thread originally posted on 08 September 2011]

    Just curious, is anyone else using Acu Cobol with MS Sql?

    Thanks

    Woody
    We mostly use dynamic SQL, but I think we may do some static queries as well.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • September 27, 2011

    [Migrated content. Thread originally posted on 08 September 2011]

    Just curious, is anyone else using Acu Cobol with MS Sql?

    Thanks

    Woody
    We mostly use dynamic SQL, but I think we may do some static queries as well.


    Terms & ConditionsAccessibility statement