AS4. 00 SQL Date Syntax. Hi all, I have a quick question about the syntax for an SQL statement I am writing. I need to know how to do an UPDATE statement such as UPDATE U2. MYFILE SET Date Created. AS4. WHERE. rest of code I know. Does anyone know the syntax I know that you use the characters in Access, but that doesnt seem to work on the pass through query I am writing for the AS4. Free Surf Expressvpn. Hi all, I have a quick question about the syntax for an SQL statement I am writing. I need to know how to do an UPDATE statement such as UPDATE U269672. Experts Exchange Questions Dynamically, referencing fields from RPGLE defined record within AS400 SQLRPGLE program I want to write the output of a qshell command to local data area so that it could be globally used by programs. Download the free trial version below to get started. Doubleclick the downloaded file to install the software. Job number T6424 Send to Friend Title Administrative Assistant, Corporate Affairs Industry Information Technology Salary Job duties Approximately 6 months. Its MDMit contains only the highest quality validated master SAP documentation and data. When you search this Wiki you know the results will only be the best and. Join Stack Overflow to learn, share knowledge, and build your career. SQL. Thanks in Advance,Greg. Join Logical File In As400 Example' title='Join Logical File In As400 Example' />Copyright c 19842017 merrill consultants dallas texas usa mxg changes 35. DATASTAGE Frequently asked Questions and Tutorials DATASTAGE Frequently asked Questions and Tutorials 1. DATASTAGE QUESTIONS 2. DATASTAGE FAQ from GEEK.