with Delphi-adoquery AS400 to access

20 pts.
Tags:
AS/400
AS/400 Query
Delphi 7.0
My question is, with Delphi-adoquery AS400 to access, but I have AS400 member at my table. How should we proceed, I need urgent help. Thank you for everything Library table field names: my library narpak2: tables mgpyvm: Members narpak2009

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    tables mgpyvm: Members narpak2009 The name of the member is not the same as the name of the table. The likely possibility as that this is not a SQL TABLE, but rather a DDS physical file (PF). Also, there is a significant chance that this PF has multiple members. Does any of that describe your 'table'? SQL has no concept of "members". If Delphi ADO queries use SQL, then special handling is probably needed. Tom
    125,585 pointsBadges:
    report
  • Zagerx
    Thanks. I made a lot of research, and I found the answer :) . First time with adocommand object I made the Alias "CREATE ALIAS NARPAK2/MGPYVM2009 FOR NARPAK2/MGPYVM (NARPAK2009)" after I made with ado query object easily query SELECT MYANA,MYMUA,MYDET,MYBAK ,SUM(case when MYBAK = 1 then MYTUT else 0 end)as Debt,SUM(case when MYBAK = 2 then MYTUT else 0 end)as Will,MYBTR FROM MGPYVM2009 WHERE MYANA=120 group by MYBTR, MYANA, MYMUA, MYDET, MYBAK
    20 pointsBadges:
    report
  • TomLiotta
    CREATE ALIAS There are two general approaches. Creating an ALIAS results in a permanent object. That can mean ongoing requirements for authorities and auditing since anyone might access it. The alternative is to use the SQL CALL statement to process an OVRDBF command to override the file to the member that you need. An override is temporary and disappears when DLTOVR is run or when the job ends. The OVRDBF can be processed as a command or it might be embedded within a registered stored procedure. You would be the one to choose whether you need a permanent object or not. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following