com.scudata.ide.spl.etl.funcMessage_en.properties Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of esproc Show documentation
Show all versions of esproc Show documentation
SPL(Structured Process Language) A programming language specially for structured data computing.
#
#Tue Oct 12 17:22:10 GMT+08:00 2021
DUpdate.originalA=Original table
CsFetch=fetch()
Joinx.desc=Join tables sequences retrieved from cursors
TCursor.m=Return a multicursor(m)
ARun.url=http\://doc.raqsoft.com/esproc/func/prunxifi.html
TUpdate.desc=Update records in a ctx table
DExecute.args=SQL args
DUpdate.keys=Key of the to-be-updated table
AGroup=group()
FImport.one=Allow line continuation when escape character \\ at the end(1)
ARename.fieldNames=Fields to be renamed
FExport.desc=Write a sequence/table sequence/record sequence to a file
CsRun=run()
TAttach=attach()
TUpdate.u=Only update(u)
TClose=close()
AGroup.url=http\://doc.raqsoft.com/esproc/func/group.html
CsGroups.desc=Group records in a cursor
TUpdate.n=Return modified records(n)
DCursorSQL.desc=Create a database cursor on a SQL statement
TUpdate.i=Only insert(i)
ConnectDriver.driver=Driver class
File=file()
FXlsWrite=xlswrite()
CsGroup.one=Only get row 1 from each group(1)
AGroups.aggregateExps=Aggregate exp.
CsGroups.url=http\://doc.raqsoft.com/esproc/func/groups.html\#__284
DCursorSQL=cursor(sql)
TAppend.desc=Append records in a cursor to an entity table
FImport.desc=Import table data from file
XXlsExport.url=http\://doc.raqsoft.com/esproc/func/xoxlsexport.html
DExecute=execute()
FXlsExport.password=The write password of the Excel file
CsJoinx.joinKeys=Join keys
ACreate=create()
FXlsOpen.w=Write in stream style; Does not support returning index(w)
CsNews.bigX=Record sequence
FXlsOpen.r=Read in stream style;sypport only xlsx files(r)
ASelect.desc=Select members of a sequence under condition
XXlsImport.url=http\://doc.raqsoft.com/esproc/func/xoxlsimport.html
CsJoinx.url=http\://doc.raqsoft.com/esproc/func/joinx.html\#_386
Joinx.one=Left join(1)
AInsert.originalTable=The table to which records are inserted
FXlsExport.desc=Write a table sequence/cursor to an Excel file
CsRename.desc=Rename field names over a cursor
TCursor.where=Filter expression
FOpen=open()
DCursorSQL.x=Auto-close connection(x)
TAttach.tableName=Table name
DUpdate.desc=Update database table
ExportFieldsDialog.renameFields=Index,OldName,NewName
FieldDefineDialog.title=Fields editor
FCursor=cursor()
DCursorSQL.i=Return a single-column SQL result set as sequence (i)
FXlsExport.aOrCs=Table sequence or cursor to be exported
DCursorSQL.d=Convert numeric data type to double data type(d)
TCursor.argn=Number of segments
TCursor.argk=Segment No.
Joinx.dstCursor=Target cursor or table
FXlsImport.desc=Retrieve data from an Excel file as table sequence
ACreate.url=http\://doc.raqsoft.com/esproc/func/create.html\#__123
FXlsWrite.desc=Write an Excel object to a file
AJoin.desc=Join table sequence and record sequence on foreign key
AGroups=groups()
DExecute.url=http\://doc.raqsoft.com/esproc/func/execute.html\#db_execute
CFetch=
XXlsClose.desc=Close XLS object
FXlsOpen.password=Password
AKeys.url=http\://doc.raqsoft.com/esproc/func/keys.html\#_399
TAppend=append()
ADerive.desc=Add a computed column to table sequence/record sequence
CsGroup.s=Sort without grouping(s)
CsGroup.q=In-memory sorting(q)
TUpdate=update()
CsJoinx.attachFields=Field expression
CsGroup.i=New group if condition is true(i)
FExport=export()
CsDerive=derive()
FImport.seperator=Seperator
ConnectDriver.URL=URL
FCreate.y=Overwrite namesake file(y)
FCreate.x=Expression of partition table
FXlsWrite.xls=XLS object
FCreate.u=Do not compress base table(u)
DialogFuncEdit.title=Function assist editor
AGroup2.desc=Calculate aggregate expression after grouping a sequence
FCreate.r=Use row storage structure(r)
FCreate.p=Segment by the first field (p)
CsSortx.sortFields=ORDER BY
ANews.url=http\://doc.raqsoft.com/esproc/func/news.html
CsGroup.qExps=Expression while (q) option selected
Joinx.srcKeys=Connect source fields
CsJoin.url=http\://doc.raqsoft.com/esproc/func/join.html\#__381
options=Options
DCursorSQL.url=http\://doc.raqsoft.com/esproc/func/cursor.html\#_131
Create=create()
AGroup2=group(x\:F,...;y\:G,...)
CsFetch.x=Close after fetch(x)
AGroup.zero=Discard records making grouping expression null(0)
AInsert.expFields=Value and their field
FExport.url=http\://doc.raqsoft.com/esproc/func/export.html\#_190
ASelect.filter=Filter expression
CsNew.url=http\://doc.raqsoft.com/esproc/func/new.html\#_462
AJoin.foreignKeys=Foreign key field
DUpdate.one=First field is self incremental(1)
AJoin.joinTable=To-be-joined table sequence
TAppend.x=Calculate zone expression at each append when a single cursor corresponds to multiple zones in a multi-zone composite table (x)
TCursor=cursor()
TUpdate.url=http\://doc.raqsoft.com/esproc/func/tupdatep1.html
DExecute.desc=Execute SQL on specified db connection
CsGroups.maxN=Max group count
CsRename=rename()
ExportFieldsDialog.fieldExps=Index,Field,Expression
CsNew.desc=Return a cursor having new field values
ANew.m=Parallel calculation(m)
ANew.i=Ignore rows making expression value null(i)
CsFetch.desc=Fetch records from a cursor or a distributed cursor
CsJoinx.u=Shuffle records in the cursor(u)
TAppend.i=Real-time append, and force append when the composite table is closed (i)
AGroups.u=Do not sort result set by grouping exp.(u)
CsJoinx.q=Match records by order(q)
AGroups.desc=Group a table sequence and get aggregates cumulatively
CsGroupx.desc=Group a cursor and return result as a cursor
AGroups.o=Merge group(o)
AGroups.n=Group by group number(n)
TAppend.a=Merge append to a patch file (a)
AGroups.m=Parallel calculation(m)
CsJoinx.i=Inner join(i)
AGroups.i=Group by bool exp.(i)
AGroups.h=High performance if data is grouped and ordered(h)
CsJoinx.d=Discard matching records if parameters x\:F are absent(d)
CsFetch.fetchN=Fetch count
CsJoinx.c=An ordered cursor speeds up matching(c)
ANew=new()
TAttach.url=http\://doc.raqsoft.com/esproc/func/attach.html
Joinx=joinx()
AGroups.groupExps=Grouping exp.
CsRun.desc=Calculate new field values on a cursor
AKeys.keys=Key fields
CsJoinx.bufferN=Buffer row count
ANews=news()
AGroups.url=http\://doc.raqsoft.com/esproc/func/groups.html
ConnectDB.level=Isolation level
File.s=AutoSearch(s)
ADelete.exp=Position of deleted records or source table
Joinx.outFields=Selected fields
CsNews=news()
ARename.desc=Raname field names
XXlsExport.desc=Write table or cursor to XLS
ARun.expFields=Value assignment exp
Joinx.url=http\://doc.raqsoft.com/esproc/func/joinx.html\#_385
CsSortx.desc=Sort a cursor
FImport=import()
CsGroup.desc=Group a cursor by comparing neighboring records
ConnectDriver.l=Return lower table or field name(l)
DExecute.s=No prepare before execute(s)
File.fn=File name
ACreate.desc=Create a new empty table
DUpdate.tableName=To-be-updated table name
ConnectDriver.e=Return error message(e)
DExecute.k=No commit after execute(k)
FXlsImport.fields=To-be-retrieved fields
TClose.desc=Close a ctx file
FCursor.desc=Create a cursor on a file
ConnectDB.l=Return lower table or field name(l)
FCursor.x=Auto-delete source file at cursor closing(x)
ConnectDB.e=Return error message(e)
TCursor.desc=Segment an entity table and return cursor of a specified segment
CsSortx=sortx()
FXlsExport.url=http\://doc.raqsoft.com/esproc/func/fxlsexport.html
AJoin.i=Inner join(i)
ConnectDB.url=http\://doc.raqsoft.com/esproc/func/connect.html
XXlsImport.desc=Import a table sequence from XLS object
FCreate.desc=Create a composite table's base table from a file
XXlsClose=xlsclose()
CsJoinx.desc=Join a cursor and a segmentable bin file via foreign key
CsJoinx.foreignKeys=Cursor's foreign key field
ConnectDriver.desc=Create connection to database
CsGroup=group()
FXlsImport.url=http\://doc.raqsoft.com/esproc/func/xlsimport.html
AKeys.desc=Set key for a table sequence
TCursor.fields=Selected fields/expression
CsFetch.url=http\://doc.raqsoft.com/esproc/func/fetch.html\#__204
ConnectDB.db=Data source name
DQuerySQL.one=Return the first-found record only and as a sequence(1)
FOpen.password=Read or write password
DUpdate.updateFields=Fields to update
EmptyWarning=\ {0} can not be empty\!
File.cs=Charset
ConnectDriver.level=Isolation level
TAttach.desc=Add an attached table to base table
FCreate.url=http\://doc.raqsoft.com/esproc/func/create.html\#__121
CsGroupx.bufferN=Buffer row count
ASelect.one=Return the 1st member(1)
FCreate.fields=Field names
CsNews.newFields=Computed column
AGroup.u=Do not sort result set(u)
AGroup.s=Return concatenation of groups(s)
AGroup.p=Return member group index sequence(p)
DialogFuncEdit.selectcell=Select a cell
AGroup.o=Merge(o)
ANews.desc=Calculate new field values to update to the original table sequence/record sequence
AGroup.n=Group by group number(n)
AGroup.i=New group if condition is true(i)
AGroup.h=Use it on sorted segments(h)
DUpdate.url=http\://doc.raqsoft.com/esproc/func/dbupdate.html
CsFetch.groupX=GROUP BY
CsJoinx=joinx()
DQuerySQL.desc=Perform a SQL query over a data source
AJoin.url=http\://doc.raqsoft.com/esproc/func/join.html\#__379
TAppend.cursorName=Cursor name
XXlsExport=xlsexport()
FXlsOpen.url=http\://doc.raqsoft.com/esproc/func/xlsopen.html
CsGroupx=groupx()
CsRun.url=http\://doc.raqsoft.com/esproc/func/csrun.html
CsGroups=groups()
FXlsOpen=xlsopen()
CsRename.url=http\://doc.raqsoft.com/esproc/func/trename.html\#cs_rename
ExportFieldsDialog.title=Fields and expressions
ANew.desc=Calculate a specified expression on a field to generate a new table sequence/record sequence
ConnectDB.desc=Create connection to database
ANew.url=http\://doc.raqsoft.com/esproc/func/new.html
FXlsImport.password=Excel file password
FXlsOpen.desc=Open an Excel file
ARename.url=http\://doc.raqsoft.com/esproc/func/trename.html
ConnectDB=connect(db)
CsNew=new()
TAttach.fields=Table columns
AInsert.r=Insert by field order(r)
FCreate=create()
FXlsExport.exportFields=Fields to be exported
DExecute.aOrCs=Batch execute table or cursor
AInsert.n=Return the inserted record or record sequence of inserted records(n)
AInsert.k=Insert position
AJoin.attachFields=SELECT exp.
AInsert.f=Insert common fields only(f)
DUpdate.u=Update only(u)
StringListDialog.title=Edit string values
TClose.url=http\://doc.raqsoft.com/esproc/func/tclose.html
FOpen.url=http\://doc.raqsoft.com/esproc/func/fopenp1.html
ARun=run()
DUpdate.k=No commit after update(k)
DUpdate.i=Insert only(i)
AInsert.url=http\://doc.raqsoft.com/esproc/func/tinsert.html
ARun.desc=Calculate new field value for each record of a record sequence
DUpdate.d=Delete only(d)
Create.desc=Create an empty table sequence
TUpdate.tableName=A same-structure record sequence to be updated
ADelete.n=Return a deleted record or a record sequence(n)
DUpdate.a=Clear table before update(a)
FieldDimDialog.exportfields=Index,Name,Dimension
FXlsExport=xlsexport()
CsGroupx.url=http\://doc.raqsoft.com/esproc/func/csgroupx.html\#cs_groupx0
AGroup.one=Only use the 1st row of each group(1)
ASelect.z=Search backward(z)
ANews.newFields=A field or computed column
ANew.newFields=A field or computed column
ASelect.t=Return an empty table sequence when result is null(t)
DCursorSQL.args=Args
ASelect.r=Select from the first eligible member to the end(r)
FXlsExport.w=Used when the original file is a sequence of sequences or a tab-separated string and parameters x\:F are absent; do not work with @t/@c (w)
FXlsExport.t=Import row 1 as field names(t)
ASelect.m=Parallel search(m)
DExecute.sql=SQL
AGroup.groupFields=Grouping exp
FXlsExport.p=Sub-option of @w for performing transposition, and ignored when source data is string (p)
Joinx.u=Target is table(u)
ADelete.desc=Delete specified records from table sequence
FXlsImport.sheetName=Sheet name
Joinx.p=Join by position(p)
ASelect.c=Select members from the first before the first ineligible member(c)
ASelect.b=Binary search(b)
ANews.bigX=Table name or an integer
Joinx.i=Delete records that do not match the foreign key(i)
AGroup.desc=Group a table sequence/record sequence by one or more specified fields
FXlsExport.c=Write a big file that can fit into the memory in stream style(c)
Joinx.f=Full join(f)
FXlsExport.a=Use orginal file format(a)
Joinx.d=Get records that do not match the foreign key when parameters x\:F are absent(d)
FXlsWrite.url=http\://doc.raqsoft.com/esproc/func/xlswrite.html
DQuerySQL=query(sql)
FImport.argn=Number of segments
AJoin=join()
FImport.argk=Segment No
ASelect=select(exp)
FieldDimDialog.title=CTX fields
AInsert=insert()
FXlsWrite.password=Password
FImport.fields=Fields
FExport.z=Write to bin file in segment(z)
CsJoin=join()
XXlsImport=xlsimport()
ConnectDriver=connect(drv,url)
ADerive=derive()
FExport.w=Use Windows-style line break(w)
FXlsExport.sheet=Sheet name
FExport.t=Export field names(t)
FOpen.desc=Open an existing ctx file or homo-name files group
AKeys=keys()
FExport.q=Quote exported text(q)
Joinx.srcCursor=Source cursor
ConnectDriver.url=http\://doc.raqsoft.com/esproc/func/connect.html
FExport.o=Use quotation marks as escape character(o)
CsJoinx.joinFile=To-be-joined bin file
DCursorSQL.sql=SQL
FExport.seperator=Text seperator
FXlsImport.w=Import as a sequence of sequences whose members are cell values;do not work with @t/@c/@b(w)
CsJoin.desc=Join a cursor and a record sequence via foreign key
CsSortx.bufferN=Buffer row count
FXlsImport.t=Import row 1 as field names(t)
CsDerive.url=http\://doc.raqsoft.com/esproc/func/derive.html\#__159
FXlsImport.s=Return an enter/tab-seperated string(s)
CsGroup.groupFields=Grouping exp
FExport.c=Comma-separated by default(c)
FExport.b=Write to bin file(b)
CsFetch.zero=Copy from cursor(0)
FXlsImport.p=Sub-option of @w for performing transposition(p)
FExport.a=Append(a)
FXlsImport.n=Trim each value and import an empty string as null(n)
AInsert.desc=Insert one or more records toa table sequence
AGroups.zero=Discard records making grouping expression null(0)
FXlsImport.c=Return result as a cursor(c)
DQuerySQL.url=http\://doc.raqsoft.com/esproc/func/query.html\#__515
FXlsImport.b=Remove blank rows before and behind a row;do not work with @c(b)
ADerive.url=http\://doc.raqsoft.com/esproc/func/derive.html
AJoin.joinKeys=Primary key field
FieldDefineDialog.tablefields=Index,Name,Type,Format
FExport.fields=To-be-exported fields
ARename=rename()
Create.fields=Field names
AGroup2.url=http\://doc.raqsoft.com/esproc/func/group.html\#__270
ADerive.x=Expand field whose values are records(x)
XXlsClose.url=http\://doc.raqsoft.com/esproc/func/xlsclose.html
ExportFieldsDialog.exportfields=Index,Expression,Name
DUpdate=update()
FXlsImport.arge=End row
TCursor.url=http\://doc.raqsoft.com/esproc/func/cursor.html\#__133
FExport.AorCs=Sequence or cursor
FXlsImport=xlsimport()
FXlsImport.argb=Begin row
FImport.v=Throw exception if error is reported(v)
TAppend.url=http\://doc.raqsoft.com/esproc/func/append.html
FImport.t=Import line 1 as field names(t)
FImport.s=Do not split to-be-retrieved field(s)
DUpdate.aOrCs=Table or cursor to update
CsSortx.n=Treat buffer row count as segmenting exp. and sort each segment(n)
FImport.q=Delete all quotation marks(q)
FImport.p=Handle parentheses and quotes match at parsing(p)
FImport.o=Escape double quotes as quotes by Excel rule(o)
FImport.n=Delete rows where column count does not match value count at line 1(n)
Joinx.dstKeys=Connect target fields
FImport.m=Return a multicursor(m)
FImport.k=Retain white spaces on both sides of a value(k)
FImport.i=Return a single-column result set as sequence
CsDerive.desc=Add one or more fields to a cursor
CsNews.desc=Calculate cursor field values and update results to the original cursor
StringListDialog.tablefields=Index,Value
FImport.f=No parse at all(f)
FImport.e=Return null when specified to-be-retrieved field does not exist(e)
CsNews.url=http\://doc.raqsoft.com/esproc/func/news.html\#__468
FImport.d=Delete a record if it contains mismatched data type or format(d)
FImport.c=Comma-separated by default(c)
FImport.b=Read from a bin file(b)
FImport.a=Treat single quotes as quotes(a)
ADelete=delete()
DialogFuncEdit.selectfunc=Select a function
CsSortx.zero=Put records with null values at the end(0)
File.desc=Open a specified file
TCursor.cursorN=Segment count in a multicursor
© 2015 - 2024 Weber Informatics LLC | Privacy Policy