1
  • How to create a SQL view of the file

    How to create a SQL VIEW of the file to present packed or binary values as characters? I know we can create an sql view using CREATE VIEW library/view1 AS SELECT * FROM library/filename.  But can anyone tell me how to present packed or binary values as characters using this? I used the command...

    vibgyor280 pointsBadges:
  • SQL view & FTP of this view

    I need to create an SQL view & do FTP of this view. CREATE VIEW palib/reshgjw AS SELECT WJWID as WJWID,char(WPEROD) as WPEROD,char(WCMPNY) as WCMPNY from libname/filename. In my text file, I need a tab b/w each fields. But in the text i got there are no field separators b/w field 1 & field...

    vibgyor280 pointsBadges:
  • CREATE SQL VIEW

    Can i provide a tab betwen two fields whicle selecting fields from a file to create an SQL view? I tried || and +. But is throwed me token not valid.

    vibgyor280 pointsBadges:
  • AS/400 Embedded SQL Dates

    Our normal QDATFMT is *MDY.  (Arrrgh!!!) I am running an SQLRPGLE that does this: **----Set Option must be first code in program.----------------* /free                                                               EXEC SQL SET...

    NickHutcheson11,380 pointsBadges:
  • How can I see SQL VIEW inside ?

    Dear Friend, I see the VIEWS on AS/400 as logical file,but I don't know wit which SQL it is created. How can I see the SQL Sentence of this VIEW ?

    Vkarakuzu20 pointsBadges:
  • SEQUEL ViewPoint

    We are using SEQUEL View point to execute some queries. We can achieve this using AS400 SQL statments itself. What is advantage of using SEQUEL View point?

    rajeshece1,215 pointsBadges:
  • Refresh a SQL View in ILE

    I have created a view and am using in an ILE module. I have updated one of the files that the view is built with. How do I refresh the View to see this record the next time I run the SQL view? Is there a CREATE OR REPLACE VIEW in RPGILE? Thank you.

    BisonHawk25 pointsBadges:
  • SQL Developer Views and Programs

    I created a view to simplify the cursor within the package body. The SQL statement being used works as expected in SQL Developer but the program returns zero records. The program worked correctly before replacing one of the tables with this view. Not sure why all of a sudden the sql statement isn't...

    Petpat12370 pointsBadges:
  • SQL View- Adding a table from a different server.

    Can I add a table from another MSSQL Server on the network to an SQL view and how?

    DUmlaut5 pointsBadges:
  • SQL View on 1 AS/400 using data from another AS/400

    We have 2 AS400 machines connected with a 1g pipe. I need to create a SQL view on one of the machines using data that is in DDS physical files on the other machine. How can I accomplish this?

    Oldtonew135 pointsBadges:
1

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