COBOL to MySQL Error Messages

  • Posts: 327
  • Thank you received: 1

COBOL to MySQL Error Messages was created by SelwynO

Hi

I am loading data into MySQL from COBOL.

There are error messages displayed during the load as per the screen shot (01) yet the transformation report shows the records have been updated.



The documentation states that each row should be terminated with an end of line - I have terminated with a TAB, CR and LF. (Hex 090D0A) See Hex Dump Screen shot.



I am available for a remote support session.

Kindest regards
Selwyn
7 years 5 months ago #9999
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 8283
  • Karma: 33
  • Thank you received: 540

Replied by admin on topic COBOL to MySQL Error Messages

No documentation does not say that

Property ApplicationSourceData

Use to SHOW DATA in source grid when Source type is dsApplication.
Format is:
“FieldValue1” tab “FieldValue2” tab “FieldValue3” end of line
“FieldValue1” tab “FieldValue2” tab “FieldValue3”

Property ApplicationSourceDataRow

Use to PASS DATA into VimpX when Source type is dsApplication.

There is a difference between showing the data to the user so user can see multiple lines of data and do the mapping
and actually loading the data.

For loading the data you must use ApplicationSourceDataRow and you must do it in correct way

Correct way

ApplicationSourceDataRow = source data to be loaded (only one line)

Incorrect way

ApplicationSourceDataRow=''
ApplicationSourceDataRow=ApplicationSourceDataRow+Field1 value
ApplicationSourceDataRow=ApplicationSourceDataRow+Field1 value
ApplicationSourceDataRow=ApplicationSourceDataRow+Field2 value
ETC

Peter
Mike
ETL Architect
7 years 5 months ago #10000

Please Log in or Create an account to join the conversation.

  • Posts: 327
  • Thank you received: 1

Replied by SelwynO on topic COBOL to MySQL Error Messages

Hi Peter.

Firstly I understand end of line to be CR LF (Hex 0D0A) without a preceding TAB.

ApplicationSourceData

This is obviously a buffer area. There are a limited no of rows that can be loaded into it. Once the buffer is full I presume I must update the source grid.
As I don't really need to display all the data in the source grid I am simply displaying the current row in the source grid then I am moving the row to the ApplicationSourceDataRow and updating the database with the same record.

It may well be that this is not what is required. If so please advise.

ApplicationSourceDataRow
This means that the ApplicationSourceDataRow contains the TAB between fields and TAB CR LF at the end of the row. This appears to be incorrect. If I remove the TAB between the fields and the TAB CR LF at the end this would be what is is expected by VimpX.

Kindest regards
Selwyn
7 years 5 months ago #10002

Please Log in or Create an account to join the conversation.

  • Posts: 8283
  • Karma: 33
  • Thank you received: 540

Replied by admin on topic COBOL to MySQL Error Messages

1 There is working example in the documentation which was created especially for you


ApplicationSourceData

This is obviously a buffer area. There are a limited no of rows that can be loaded into it. Once the buffer is full I presume I must update the source grid.
As I don't really need to display all the data in the source grid I am simply displaying the current row in the source grid then I am moving the row to the ApplicationSourceDataRow and updating the database with the same record.


2 This not a buffer area and it is not being used during loading the data, It is is only used to show show the user the data in source grind so the user can do the mapping. You may just show one record if you wish


ApplicationSourceDataRow
This means that the ApplicationSourceDataRow contains the TAB between fields and TAB CR LF at the end of the row. This appears to be incorrect. If I remove the TAB between the fields and the TAB CR LF at the end this would be what is is expected by VimpX.

3 Again there is working example in the documentation. again there no CR-LF in this example

Peter
Mike
ETL Architect
7 years 5 months ago #10003

Please Log in or Create an account to join the conversation.

  • Posts: 327
  • Thank you received: 1

Replied by SelwynO on topic COBOL to MySQL Error Messages

All your comments are noted.

The only change I have made is I have removed the cr-lf from the ApplicationSourceDataRow.

The results are exactly the same as described above with the same errors.
I suspect there may be an error in the property "CurrentStatus".

Selwyn
7 years 5 months ago #10005

Please Log in or Create an account to join the conversation.

  • Posts: 8283
  • Karma: 33
  • Thank you received: 540

Replied by admin on topic COBOL to MySQL Error Messages

UnTick abort import if it is selected and run it again




Peter
Mike
ETL Architect
7 years 5 months ago #10006
Attachments:

Please Log in or Create an account to join the conversation.

 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies