This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / 请教AS400 的问题，请各位大侠不吝赐教！请问如何CREATE JOB SCHEDULE FOR QUERY， WHICH IS MADE IN QUERY MANAGER， TYPE IS *QMQRY， ATTRIBUTE IS *SQL。我用RUNQRY COMMAND，但是错误信息说没有该QUERY，我知道一般可以RUN *QRYDFN，但我的QUERY 是QM下的SQL。该如何输入CL，建立JOB呢？
万分感谢不吝赐教的各位大侠！
-lasthope(HOPE);
2005-10-14
{263}
(#2553672@0)
-
Try STRPDM to create CL
-greenwhistle(I do not know);
2005-10-14
(#2553682@0)
-
谢谢！我就是不知道除了RUNQRY <query_name> 以外,还能用什么CL COMMAND 来执行. 因RUNQRY只适用与*QRYDFN TYPE, NOT *QMQRY TYPE. 请问用什么CL 来执行呢? 急需建立JOB SCHEDULE. 谢谢!
-lasthope(HOPE);
2005-10-14
(#2553746@0)
-
your requirements need three step but it is very sample1 strqry, create query depond on your requirement ,setting one by one
2 strpdm create cl pgm runqry with that name
3 wrkjobscde add one shedule job to call this cl pgm
play it , not to hard.
-nolater(nolater);
2005-10-14
{201}
(#2553768@0)
-
Thank you for your support very much! My problem is,The problem is, my Query was not built in STRQRY, because I have to use left outer join statement. So I have to write the sql statement under Query Manage, this is why my query type is not *QRYDFN (which will be gotten from STRQRY). My query type is *QMQRY, so when I use RUNQRY, the message said the query file can't be found. Thank YOu! Please, please 赐教！
-lasthope(HOPE);
2005-10-14
{368}
(#2553781@0)
-
写个CLP，用STRQMQRY去执行你的 *QMQRY， 然后对CLP建一个 SCHEDULE JOB控制运行。
-aristotle(中英文大小写均可);
2005-10-14
(#2553815@0)
-
Thanks! 我试试， 十分感谢！
-lasthope(HOPE);
2005-10-14
(#2553817@0)
-
*QMQRY实际就是一组SQL语句，对于没有购买SQL嵌入语言包的AS400用户来讲， STRQMQRY是一个打包在最基本OS里一个可以实现SQL功能的命令，算是免费的吧。
-aristotle(中英文大小写均可);
2005-10-14
(#2553836@0)
-
你说的很对，我就是在*QMQRY下写了SQL。不好意思再问一句，如果我用CLP，先写STRQMQRY，再写RUN QUERY <QUERY_NAME> 吗？因现在没有上机环境, 实在是想搞明白. 再此多谢了!
-lasthope(HOPE);
2005-10-14
(#2553944@0)
-
不需要再运行RUNQRY了。
-aristotle(中英文大小写均可);
2005-10-14
(#2554020@0)
-
那在STRQMQRY后写什么呢？直接加上 <QUERY_NAME> 吗? 总觉得少点什么。要是能上机试就好了. 再次表示感谢!
-lasthope(HOPE);
2005-10-14
(#2554052@0)
-
STRQMQRY QMQRY(the object you created with type *QMQRY)
-aristotle(中英文大小写均可);
2005-10-14
(#2554077@0)
-
Great! Thank you so much, 高人！
-lasthope(HOPE);
2005-10-14
(#2554081@0)
-
STRQRY -> 1 Work with Query -> 1 create-> 1 specify file selections -> define others, such as record, fields, results ...
-guest1(guest);
2005-10-16
(#2555508@0)
-
How do you use STRQRY to create a query with LEFT OUTER JOIN? Because I don't know it, that is why I use STRQM to create the query using SQL. And this is the reason that I can't use RUNQRY to run it.
-lasthope(HOPE);
2005-10-16
(#2556031@0)
-
You can create a basic query in STRQRY first. the type of that query is PROMPT, then convert it to SQL type. In SQL you can join the table using any kind of join as you like.
-greenwhistle(I do not know);
2005-10-16
(#2556038@0)
-
Yes, this is what I did. However, it is not STRQRY, it is STRQM. The type is not *QRYDFN, it is *QMQRY.
-lasthope(HOPE);
2005-10-16
(#2556297@0)
-
You didn't get us.If you go to STRQRY-->10, it's the same thing with type STRQM directly. that's I normally do. I never use Query for AS/400. In the CLP you can use what (aristotle
Nick: 中英文大小写均可 ) told you.
-greenwhistle(I do not know);
2005-10-17
{204}
(#2557268@0)
-
In my humble opinion.1. matched output to filea, 2. unmatched to putput file b 3. cpyf filea,fileb to filec.
-aka(棒棒);
2005-10-16
(#2556113@0)
-
"Well, I wasn't that far, was I?" -- A guy with a big spoon at Tim Hortons
-aka(棒棒);
2005-10-17
(#2557942@0)
-
create a VIEW or Logical file first.
-guest1(guest);
2005-10-16
(#2556694@0)