modify_file_list

某高校高性能计算集群部署文档（瘦节点部分）2012年11月25日目录1.文档更新历史........................................................................................................ 错误!未定义书签。

2.集群概览 (5)3.准备工作 (5)3.1.对所有节点的内置硬盘建立RAID (5)3.2.收集物理信息 (6)4.部署管理节点操作系统 (6)4.1.安装操作系统 (6)4.2.系统安装完之后配置 (7)5.安装配置Platform HPC集群管理软件 (8)5.1.安装包准备 (8)5.2.执行安装程序 (8)5.3.安装过程中的操作 (8)6.使用Platform HPC做操作系统分发 (9)6.1.配置网络接口 (9)6.2.为刀片机HS22操作系统分发 (12)6.3.对刀片组HS12操作系统分发 (16)6.4.对IO节点做系统分发 (20)6.5.对Login节点做系统分发 (23)7.使用Platform HPC维护操作系统分发 (26)7.1.移除已经部署的操作系统 (26)7.2.重新部署操作系统 (26)7.3.部署新的机器 (27)7.4.维护部署模板内容 (28)8.GPFS配置方法 ...................................................................................................... 错误!未定义书签。

8.1.XIV近线存储划分 ..................................................................................... 错误!未定义书签。

8.2.XIV存储驱动安装 ..................................................................................... 错误!未定义书签。

第一章测试1.Which is NOT the main part of computer ( )A:I/O equipmentB:CacheC:CPUD:memory答案:B2.Which symbol can be used for comments in Python ( )A:#B:“C://D:!答案:AB3.The integrated development tool built into Python is ( ).A:JupyterB:PycharmC:IDLED:Vs code答案:C4.Which is the correct operator for power(Xy)? ( )A:X^yB:None of the mentionedC:X yD:X^^y答案:C**5.Which of the following is incorrect? ( )A:float(“3+5”)B:float(“3”)C:float(4.2)D:float(3)答案:A第二章测试1.Which of the following is an invalid variable? ( )A:1st_stringB:my_string_1C:_D:foo答案:A2.What will be the output of the following Python code ? not(10＜20) andnot(10＞30) ( )A:ErrorB:TrueD:No output答案:C3.Which one will return error when accessing the list ‘l’ with 10 elements. ( )A:l[0]B:l[-10]C:l[10]D:l[-1]答案:C4.What will be the output of the following Python code?lst=[3,4,6,1,2]lst[1:2]=[7,8]print(lst) ( )A:Syntax errorB:[3,4,6,7,8]C:[3, 7, 8, 6, 1, 2]D:[3,[7,8],6,1,2]答案:C5.Which of the following operations will rightly modify the value of theelement? ( )答案:D6.The following program input data: 95, the output result is? ( )A:none of the mentionedB:Please enter your score: 95Your ability exceeds 85% of people!C:Please enter your score: 95Awesome!D:Please enter your score: 95Awesome!Your ability exceeds 85% of people!答案:D第三章测试1.Which one description of condition in the followings is correct? ( )A:The condition 24＜=28＜25 is legal, and the output is FalseB:The condition 35＜=45＜75 is legal, and the output is FalseC:The condition 24＜=28＜25 is illegalD:The condition 24＜=28＜25 is legal, and the output is True答案:A2.The output of the following program is? ( )A:PythonB:NoneC:pythonD:t答案:B3. for var in ___: ( )A:range(0,10)B:13.5C:[1,2,3]答案:B4.After the following program is executed, the value of s is？( )A:19B:47C:46D:9答案:D5.Which is the output of the following code?a = 30b = 1if a ＞=10:a = 20elif a＞=20:a = 30elif a＞=30:b = aelse:b = 0print(“a=”,a,“b=”,b) （）A:a=20, b=20B:a=30, b=30C:a=20, b=1D:a=30, b=1答案:C第四章测试1.Which keyword is used to define a function in Python? ( )A:funB:defineC:defD:function答案:C2.What will be the output of the following Python code? ( )A: x is 50Changed local x to 2x is now 50B:x is 50Changed local x to 2x is now 100C:None of the mentionedD:x is 50Changed local x to 2x is now 2答案:A3.Which are the advantages of functions in Python? ( )A:Improving clarity of the codeB:Reducing duplication of codeC:Easier to manage the codeD:Decomposing complex problems into simpler pieces答案:ABCD4.How does the variable length argument specified in the function heading? ( )A:one star followed by a valid identifierB:two stars followed by a valid identifierC:one underscore followed by a valid identifierD:two underscores followed by a valid identifier答案:A5.What will be the output of the following Python code? list(map((lambdax:x2), filter((lambda x:x%2==0), range(10)))) ( )A:[0, 1, 2, 3, 4, 5, 6, 7, 8, 9]C:[0, 4, 16, 36, 64]D:No output答案:C**第五章测试1.Which of the following statements cannot create a demo.txt file? ( )A:f = open(“demo.txt”, “w”)B:f = open(“demo.txt”, “r”)C:f = open(“demo.txt”, “x”)D:f = open(“demo.txt”, “a”)答案:B2.After executing the following procedure, what content will be saved in thefile？file=open(‘test.txt’, ‘wt+’)file.write(‘helloSCUT’)file.close()file=open(‘test.txt’, ‘at+’)file.write(‘hello world’)file.close() ( )A:hello SCUThello worldB:hello SCUT hello worldC:hello SCUT worldD:hello world答案:A3.Which function is not the way Python reads files. ( )A:readlines()B:readline()C:read()D:readtext()答案:D4.How to rename a file in Python? ( )A:os.rename(fp, new_name)B:os.set_name(existing_name, new_name)C:os.rename(existing_name, new_name)D: = ‘new_name.txt’答案:C5.What is the usage of tell() function in Python? ( )A:tells you the current position within the fileB:tells you the end position within the fileC:none of the mentionedD:tells you the file is opened or not答案:A第六章测试1.What will be the output of the following Python code? ( )A:Reports error as one argument is required while creating the objectB:Runs normally, doesn’t display anythingC:Reports error as display function requires additional argumentD:Displays 0, which is the automatic default value答案:A2.What will be the output of the following Python code? ( )A:ErrorB:‘Old’C:Nothing is printedD:‘New’答案:B3.What will be the output of the following Python code? ( )A:mainB:Exception is thrownC:DemoD:test答案:A4.Which one of the followings is not correct about Class hierarchy? ( )A:Subclass can not add more behavior/methodsB:Subclass can override the methods inherited from superclassC:Subclass can have methods with same name as superclassD:Subclass can inherit all attributes from superclass答案:A5.What will be the output of the following Python code? ( )A:Error because class B inherits A but variable x isn’t inheritedB:0 1C:0 0D:Error, the syntax of the invoking method is wrong答案:B第七章测试1.Numpy is a third party package for ____ in Python? ( )A:Lambda functionB:ArrayC:FunctionD:Type casting答案:B2.How to convert a Numpy array to a list in Python? ( )A:array.listB:list.arrayC:list(array)D:list.append(array)答案:C3.Which keyword is used to access the Numpy package in Python? ( )A:loadB:importC:fromD:fetch答案:B4.Which one is correct syntax for the ‘reshape()’ function in Numpy? ( )A:array.reshape(shape)B:reshape(shape,array)C:reshape(shape)D:reshape(array,shape)答案:D5.What will be the output for the following code? import numpy as np a =np.array([1, 2, 3], dtype = complex) print(a) ( )A:[[ 1.+0.j, 2.+0.j, 3.+0.j]]B:[ 1.+0.j]C:ErrorD:[ 1.+0.j, 2.+0.j, 3.+0.j]答案:D第八章测试1.Which one isn’t the method of Image.transpose？ ( )A:TRANSPOSEB:FLIP_LEFT_RIGHTC:ROTATE_90D:STRETCH答案:D2.Which one isn’t the method of ImageFilter? ( )A:ImageFilter.DETAILB:ImageFilter.BLURC:ImageFilter.EDGE_ENHANCED:ImageFilter.SHARP答案:D3.Which one is attribute of image? ( )A:modeB:sizeC:colorD:format答案:ABD4.Which operation can be used to set the picture to a given size? ( )A:resize()B:crop()C:thumbnail()D:transpose()答案:A5.What is the effect of ImageFilter. CONTOUR? ( )A:Blur the pictureB:Sharp the imageC:Smooth the pictureD:Extract lines in the picture 答案:D。

#include<iostream.h>#include<process.h>#include<fstream.h>#include<stdlib.h>#include<string.h>#include<iomanip.h>class AddrList;class Node{char ID[20];char Name[20];char OfficePhone[20];char HomePhone[20];char MobilePhone[20];char Email[20];Node *Next;public:Node(char* id=0,char *name=0,char* op=0,char* hp=0,char *mp=0,char *email=0,Node *next=NULL){strcpy(ID,id);strcpy(Name,name);strcpy(OfficePhone,op);strcpy(HomePhone,hp);strcpy(MobilePhone,mp);strcpy(Email,email);Next=next;}void Show(){cout<<setw(12)<<ID<<setw(6) <<Name<< setw(12) <<OfficePhone<< setw(12) <<HomePhone<<setw(12)<<MobilePhone<<setw(20)<<Email<<endl;}friend class AddrList;friend void add(AddrList &addrlist);friend void query(AddrList &addrlist);friend void modify(AddrList &addrlist);};class AddrList{Node *HeadPtr;int Tag;public:AddrList(Node *headptr=NULL,Node *tailptr=NULL,int tag=0){ //构造函数，创建空链表，将Tag的值置为1HeadPtr=headptr;Tag=tag;} //将p指向的结点加入到链表尾部void AddSort(char* id,char *name,char* op,char* hp,char *mp,char *email);//将p指向的结点按Tag指定的顺序插入到链表中Node *LookUp(char *name); //按姓名查找结点，返回该结点指针void Delete(char *name);//删除指定姓名的结点int Sort(int); //按tag指定的关键字重新排序int ShowAll() ;//显示全部结点，每10个显示一//取Tag的值//统计链表中结点个数//取首指针~AddrList();//释放链表空间void CreateList(char *filename);//从二进制文件中读入数据，构造链表void WriteToFile(char *filename); //将链表中数据写入指定的二制文件void WriteToTxtFile(char *filename); //将链表写到文本文件中void CreateFromTxt(char *filename);friend void sort(AddrList &addrlist); // 按姓名或办公室电话排序};void AddrList::AddSort(char* id,char *name,char* op,char* hp,char *mp,char *email) //将p指向的结点按Tag指定的顺序插入到链表中{Node *p;p=new Node(id,name,op,hp,mp,email);Node* x1=HeadPtr;Node* x2=x1;if( id){if(HeadPtr){while(x1=x1->Next) {x2=x1;}x2->Next=p;p->Next=NULL;}else HeadPtr=p,p->Next=NULL;}}Node * AddrList::LookUp(char *name) //按姓名查找结点，返回该结点指针{Node* x=HeadPtr;while(x!=NULL && strcmp(x->Name,name)!=0) {x=x->Next;}if(x) {return x;}else return 0;}void AddrList::Delete(char *name) //删除指定姓名的结点{Node* x1=HeadPtr;Node *x2=x1;while(strcmp(x2->Name,name)!=0 && x2!=NULL) {x1=x2;x2=x2->Next;} if(x1!=x2){if(x2){x1->Next=x2->Next;delete x2;cout<<"已删除"<<endl;}else {cout<<"未找到，请确认后再输入"<<endl;}}else {HeadPtr=x1->Next;delete x2;}}int AddrList::Sort(int T_T) //按tag指定的关键字重新排序{switch(T_T){case 1:{Node* x=HeadPtr,*t;if(!HeadPtr) return 0;int m=0,n=0;Node *p[100]={0};while(x) {p[m]=x;m++;x=x->Next;}n=m;int i, j, k;for (i=0; i<n-1; i++){k=i;for (j=i+1; j<n; j++){if(strcmp(p[j]->Name,p[k]->Name)<=0){k=j;}}{t=p[k]; p[k]=p[i]; p[i]=t;}}HeadPtr=p[0];i=0;while(i<m-1){p[i]->Next=p[i+1];i++;}p[i]->Next=NULL;Tag=1;break;}case 2:{Node* x=HeadPtr,*t;if(!HeadPtr) return 0;int m=0,n=0;Node *p[100]={0};while(x) {p[m]=x;m++;x=x->Next;}n=m;int i, j, k;for (i=0; i<n-1; i++){k=i;for (j=i+1; j<n; j++){if(strcmp(p[j]->ID,p[k]->ID)<=0){k=j;}}{t=p[k]; p[k]=p[i]; p[i]=t;}}HeadPtr=p[0];i=0;while(i<m-1){p[i]->Next=p[i+1];i++;}p[i]->Next=NULL;Tag=2;break;} }}int AddrList::ShowAll() //显示全部结点，每10个显示一屏{Node* x=HeadPtr;if(x);else return 0;int i=1;while(1){cout << setw(12)<<"学号"<<setw(6) <<"姓名"<< setw(12) <<"办公电话"<< setw(12) <<"家庭电话"<<setw(12)<< "移动电话"<<setw(20)<<"电子邮件"<<endl;while(i<=10){x->Show();i++;if(x=x->Next);else break;}system("pause");i=1;if(x);else break;}}AddrList::~AddrList() //释放链表空间{Node *x1=HeadPtr;Node *x2=x1;while(x2=x2->Next){delete x1;x1=x2;}delete x2;}void AddrList::CreateList(char *filename) //从二进制文件中读入数据，构造链表{char a[30]={0},b[30]={0},c[30]={0},d[30]={0},e[30]={0},f[30]={0};ifstream in(filename,ios::binary);while(in>>a){in>>b>>c>>d>>e>>f;AddSort(a,b,c,d,e,f);}in.close();}void AddrList::CreateFromTxt(char *filename) //从文本文件中读入数据，构造链表{char a[30],b[30],c[30],d[30],e[30],f[30];ifstream in(filename);while(in>>a){in>>b>>c>>d>>e>>f;AddSort(a,b,c,d,e,f);}}void AddrList::WriteToFile(char *filename) //将链表中数据写入指定的二进制文件{Node *p=HeadPtr;ofstream out(filename,ios::binary);out<<p->ID<<" ";out<<p->Name<<" ";out<<p->OfficePhone<<" ";out<<p->HomePhone<<" ";out<<p->MobilePhone<<" ";out<<p->Email<<" ";while(p=p->Next){out<<p->ID<<" ";out<<p->Name<<" ";out<<p->OfficePhone<<" ";out<<p->HomePhone<<" ";out<<p->MobilePhone<<" ";out<<p->Email<<" ";}out.close();}void AddrList::WriteToTxtFile(char *filename) //将链表写到文本文件中{Node *x=HeadPtr;ofstream out(filename);out << setw(12)<<"学号"<<setw(6) <<"姓名"<< setw(12) <<"办公电话"<< setw(12) <<"家庭电话"<<setw(12)<< "移动电话"<<setw(20)<<"E-mail"<<endl;out<<setw(12)<<x->ID<<setw(6) <<x->Name<< setw(12) <<x->OfficePhone<< setw(12) <<x->HomePhone<<setw(12)<<x->MobilePhone<<setw(20)<<x->Email<<endl;while(x=x->Next){out<<setw(12)<<x->ID<<setw(12) <<x->Name<< setw(12) <<x->OfficePhone<< setw(12) <<x->HomePhone<<setw(12)<<x->MobilePhone<<setw(12)<<x->Email<<endl;}out.close();}void DisplayMenu() //显示菜单{int i;char *menu[]={ " "," "," "," "," ***********小巧通讯录管理系统************* "," "," 1. 新增一个联系人"," 2. 删除一个联系人"," 3. 显示所有联系人"," 4. 查找联系人"," 5. 更改联系人记录"," 6. 从TXT文档中增加记录"," 7. 导出联系人到Txt文档"," 8. 排序"," 9. 退出"," ","****************************************** "," "" ^_^ 欢迎使用^_^" ,NULL } ;system("cls");for(i=0;menu[i];i++)cout << menu[i]<<endl;cout<< "请选择(1--9) :";}void add(AddrList &addrlist) //按当前Tag标志插入结点，插入结点后，链表仍然保持升序{system("cls");char a[30],b[30],c[30],d[30],e[30],f[30];cout<<" 添加记录"<<endl<<" **************************************"<<endl<<" 请输入一个联系人数据"<<endl;cout << "学号"<<setw(6) <<"姓名"<< setw(12) <<"办公电话"<< setw(12) <<"家庭电话"<<setw(12)<< "移动电话"<<setw(20)<<"电子邮件"<<endl;cin>>a>>b>>c>>d>>e>>f;addrlist.AddSort(a,b,c,d,e,f);cout<<"添加完成"<<endl;system("pause");}void del(AddrList &addrlist) //删除一个结点{system("cls");char p[30];cout<<" 删除记录"<<endl<<" **************************************"<<endl<<" 请输入一个联系人的姓名"<<endl;cin>>p;addrlist.Delete(p);cout<<"删除完成"<<endl;system("pause");}void showall(AddrList &addrlist) //显示所有结点{system("cls");cout<<" 显示所有联系人"<<endl<<" **************************************"<<endl;if(addrlist.ShowAll()) ;else cout<<"空记录！"<<endl;system("pause");}void query(AddrList &addrlist) //按姓名查找一个结点{system("cls");char name[30];Node *p;cout<<" 查找联系人"<<endl<<" **************************************"<<endl<<" 请输入一个联系人的姓名"<<endl;cin>>name;if(p=addrlist.LookUp(name)){cout<< setw(12)<<"学号"<<setw(6) <<"姓名"<< setw(12) <<"办公电话"<< setw(12) <<"家庭电话"<<setw(12)<< "移动电话"<<setw(20)<<"电子邮件"<<endl<<setw(12)<<p->ID<<setw(6) <<p->Name<< setw(12) <<p->OfficePhone<< setw(12) <<p->HomePhone<<setw(12)<<p->MobilePhone<<setw(12)<<p->Email<<endl;}else cout<<"未找到"<<endl;system("pause");}void modify(AddrList &addrlist) //修改一个结点{system("cls");char name[30];Node *p;cout<<" 修改联系人"<<endl<<" **************************************"<<endl<<" 请输入一个联系人的姓名"<<endl;cin>>name;if(p=addrlist.LookUp(name)){cout<<"请输入修改后的联系人"<<endl;cout << "学号"<<setw(6) <<"姓名"<< setw(12) <<"办公电话"<< setw(12) <<"家庭电话"<<setw(12)<< "移动电话"<<setw(20)<<"电子邮件"<<endl;cin>>p->ID>>p->Name>>p->OfficePhone>>p->HomePhone>>p->MobilePhone>>p->Email;cout<<"修改完成"<<endl;}else cout<<"未找到"<<endl;system("pause");}void addfromtxtfile(AddrList &addrlist) //从正文文件增加记录{system("cls");char filename[30];cout<<" 从TXT文档中增加记录"<<endl<<" **************************************"<<endl<<" 请输入要加入的文件名"<<endl;cin>>filename;addrlist.CreateFromTxt(filename);cout<<"载入完成"<<endl;system("pause");}void writetotxtfile(AddrList &addrlist) //将链表写到正文文件中{system("cls");char filename[30];cout<<" 导出联系人到Txt文档"<<endl<<" **************************************"<<endl<<" 请输入要导出的文件名"<<endl;cin>>filename;addrlist.WriteToTxtFile(filename);cout<<"导出完成"<<endl;system("pause");}void sort(AddrList &addrlist) // 按姓名或办公室电话排序{system("cls");int T_T;int choice=0;switch(addrlist.Tag){case 0: {cout<<"此文档未排序"<<endl;break;}case 1: {cout<<"此文档已按"<<"姓名"<<"排序,将按另一种方式排序"<<endl;break;}case 2: {cout<<"此文档已按"<<"学号"<<"排序,将按另一种方式排序"<<endl;break;}}cout<<"请输入排序方式：1.姓名2.学号"<<endl;cin>>T_T;if(addrlist.Sort(T_T))cout<<"已排序"<<endl;else cout<<"空记录！";system("pause");}void quit(AddrList &addrlist) //退出前将链表写入二进制文件中{addrlist.WriteToFile("通讯录数据文件.bin");}void main(){system("color 0A");int choice=0,state;char ch;AddrList addrlist;addrlist.CreateList("通讯录数据文件.bin"); //从二进制文件中读入数据，构建链表while (choice!=9){DisplayMenu(); //显示主菜单cin>>ch;if (ch < '1' || ch > '9') continue;choice=ch-'0';switch (choice){case 1: add(addrlist); break;case 2: del(addrlist); break;case 3: showall(addrlist); break;case 4: query(addrlist); break;case 5: modify(addrlist); break;case 6: addfromtxtfile(addrlist); break;case 7: writetotxtfile(addrlist); break;case 8: sort(addrlist); break;case 9: quit(addrlist); break;}system("cls");}}。

一、内存变量常用命令1、赋值STORE <表达式>TO <变量名表><内存变量名>=<表达式>2、显示LIST|DISPLAY MEMORY [LIKE<通配符>] [TO PRINTER[PROMPT]|TO FILE<文本文件名>]3、清除CLEAR MEMORY RELEASE <变量名表>RELEASE ALL [LIKE<通配符>|EXCEPT<通配符>]4、保存SA VE TO <内存变量文件名>[ALL LIKE|EXCEPT<通配符>]5、恢复RESTORE FROM <内存变量文件名> [ADDITIVE]二、表结构操作命令1、创建表CREATE <表名>2、修改结构MODIFY STRUCTURE3、显示结构LIST|DISPLAY STRUCTURE [TO PRINTER[PROMPT]|TO FILE<文本文件名>]4、复制结构COPY STRUCTURE TO <表名> [FIELDS<字段名表>] *生成表结构文件COPY STRUCTURE TO <表结构文件名> EXTENDED5、表结构文件还原成表结构CREATE <表名> FROM <表结构文件名>三、表记录操作命令1、表打开关闭USE <表名>CLOSE DA TABASES2、显示LIST|DISPLAY [OFF] [范围] [FIELDS<字段名表>] [FOR<条件>] [WHILE<条件>][TOPRINTER[PROMPT]|TO FILE<文本文件名>]3、追加APPEND [BLANK]APPEND FROM <表名>4、插入INSERT [BLANK] [BEFORE]五修改替换EDITCHANGEBROWSEREPLEASE [范围] <字段名1> WITH <表达式1>[,<字段名2> WITH <表达式2>…][FOR<条件>] [WHILE<条件>]6、逻辑删除与恢复DELETE [范围] [FOR<条件>] [WHILE<条件>] RECALL [范围] [FOR<条件>] [WHILE<条件>]7、物理删除PACKZAP8、表文件复制COPY TO <表名> [范围] [FIELDS<字段名表>] [FOR<条件>] [WHILE<条件>]9、指针定位绝对移动GO [TOP] [BOTTOM] [N]相对移动SKIP四、排序与索引命令一排序SORT TO <表名> ON <字段名1> [/A|/D][/C] [,<字段名2> [/A|/D][/C]…] [ASCENDING|DESCENDING] [范围] [FIELDS<字段名表>] [FOR<条件>] [WHILE<条件>]2、建立索引单索引INDEX ON <索引表达式> TO <单索引文件名> [FOR<条件>] [UNIQUE] [ADDITIVE] [COMPACT]复合索引INDEX ON <索引表达式> TAG <标记名> [OF<复合索引文件名>][FOR<条件>] [ASCENDING|DESCENDING] [UNIQUE] [ADDITIVE]3、设置主控索引SET ORDER TO [<数值表达式>|<单索引文件名>|[TAG]<标记名>[OF<复合索引文件名>]] [ASCENDING|DESCENDING]4、打开索引文件SET INDEX TO [<索引文件名表>] [ORDER <数值表达式>|<单索引文件名>|[TAG]<标记名>[OF<复合索引文件名>]] [ASCENDING|DESCENDING] [ADDITIVE]USE <表名> INDEX<索引文件名表> [ORDER <数值表达式>|<单索引文件名>|[TAG]<标记名>[OF<复合索引文件名>]] [ASCENDING|DESCENDING]5、索引文件更新REINDEX *删除索引DELETE TAG <标记名>|ALL [OF<复合索引文件名>]五、数据查询与筛选命令1、直接查询LOCATE [范围] [FOR<条件>] [WHILE<条件>]继续查找CONTINUE2、索引查询FIND <字符常量>|<数值常量> SEEK <表达式>继续查找SKIP3、筛选SET FILTER TO [<表达式>]六、统计命令1、记录个数COUNT [TO <变量名>] [范围] [FOR<条件>] [WHILE<条件>]2、求和SUM [<数值表达式表>] [范围] [FOR<条件>] [WHILE<条件>] TO <内存变量名表>|TO ARRAY <数组名>3、求平均值A VERAGE [<数值表达式表>] [范围] [FOR<条件>] [WHILE<条件>] TO <内存变量名表>|TOARRAY <数组名>4、分类汇总TOTAL ON <关键字> TO <表名> [FIELDS <数值字段名表>] [范围] [FOR<条件>] [WHILE<条件>]七、多工作区操作命令1、打开表USE <表名> [ALIAS<别名>] [IN<工作区号|工作区别名|表别名>] [AGAIN]2、工作区选择SELECT<工作区号>|<别名>|03、建立关联SET RELATION TO <关联表达式1> INTO <别名> [,<关联表达式2> INTO <别名>…][ADDITIVE]4、解除关联SET RELATION TOSET RELATION OFF INTO <别名>5、一对多关联SET SKIP TO [<别名1>[,<别名2>…]]6、连接命令JOIN WITH <别名> TO <表名> FOR<条件> FIELDS<字段名表>7、更新UPDA TE ON <字段名> FROM <别名> REPLACE <字段名1> WITH <表达式1>[,<字段名1> WITH <表达式1>…][RANDOM]八、程序设计内容1、建立程序MODIFY COMMAND <程序文件名>2、执行程序DO <程序文件名> [WITH <参数表>]3、注释语句NOTE*&&4、输入输出非定位输入WAIT ACCEPT INPUT 非定位输出???定位输入输出@行,列SAYGET(用GET时需要用READ)5、程序控制语句IF语句DO CASE语句DO WHILE语句FOR语句SCAN语句九、过程及过程调用——子程序1、定义: PROCEDURE<过程名>语句序列RETURN2、位置:在程序文件的末尾,或若干个过程组成一个文件,过程文件(常用方法)3、过程的调用DO 过程名[IN 文件名]4、打开关闭过程文件打开SET PROCEDURE TO <过程文件名>关闭SET PROCEDURE TOCLOSE PROCEDURE5、调用过程的查找顺序调用过程的程序文件SET PROCEDURE 命令打开的过程文件名为过程名的程序文件6、返回RETURNRETURN TO MASTERRETURN TO 过程名7、过程的参数传递PARAMETERS <参数表>它是过程中的第一句特点:加()按值传送(不改变主调用程序中的值)不加()按地址传送(改变主调用程序中的值)十、自定义函数——子程序的另一种形式1、定义FUNCTION <函数名>语句序列RETURN <表达式>2、调用格式自定义函数名(参数表)3、参数传递SET UDFPARMS TO V ALUE|REFERENCE*加括号按值FUN2((X),(Y))十一、内存变量作用域根据内存变量的作用范围分为全局变量，局部变量。