All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.scudata.ide.spl.etl.funcMessage_en.properties Maven / Gradle / Ivy

Go to download

SPL(Structured Process Language) A programming language specially for structured data computing.

There is a newer version: 20240823
Show newest version
#
#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