SoftadminUtil.P27_Camt_054_001_02_Parse

Type: Stored procedure

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();
SELECT * INTO #P27CreditNotificationDetails FROM SoftadminUtil.P27_Camt_CreditNotificationDetails_Definition();

DECLARE @ErrorMessage nvarchar(MAX);

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

See also

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.
Table count:
Row count:
Columns

Resultset: #P27CreditNotification

A temporary table that will be filled by the procedure.
Table count:
Row count:
Columns

Resultset: #P27CreditNotificationDetails

A temporary table that will be filled by the procedure.
Table count:
Row count:
Columns