SoftadminUtil.P27_Camt_054_001_02_Parse

 Show all Hide all

Parses camt.054.001.02 files.

Example

SELECT * INTO #P27DebitNotification FROM SoftadminUtil.P27_Camt_DebitNotification_Definition();
SELECT * INTO #P27CreditNotification FROM SoftadminUtil.P27_Camt_CreditNotification_Definition();

DECLARE @ErrorMessage nvarchar(MAX);

EXEC SoftadminUtil.P27_Camt_054_001_02_Parse
	@Varbinary = @File,
	@ErrorMessageOut = @ErrorMessage OUTPUT;

See also

Type: Stored procedure
Area of use: General use

Parameters:

@ErrorMessageOut mandatory nvarchar
Error message intended for the developer if the file could not be parsed. The procedure will also have a negative return value when errors occur.
@Varbinary optional varbinary
The file to be parsed in UTF-8 encoding. Only one of @Varbinary and @Xml should be provided.
@Xml optional xml
The file to be parsed. Only one of @Varbinary and @Xml should be provided.

Resultsets:

Resultset: #P27DebitNotification

A temporary table that will be filled by the procedure.
Repeat mode:
Row count:

Columns:

Resultset: #P27CreditNotification

A temporary table that will be filled by the procedure.
Repeat mode:
Row count:

Columns: