Hi,
We are getting the warning "main_program: Invalid character conversion found converting to ASCL_MS1252, substituting." while running the parallel job more than once with the same file.(First run is successful)
The database which we are loading the file to is DB2 and we are using DB2/UDB API stage in our parallel job for this purpose.The execution mode is set to "Parallel" and the update action is "Insert new or update existing rows".
But when we run the job with the same file more than once,keeping the execution mode as "sequential", it is running fine without any warnings.
ASCL_MS1252 error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
I can only guess that ASCL_MS1252 is a reference to Ascential's implementation of Microsoft code page 1252 (US English).
Is there any more information in the job log?
What are your DataStage NLS settings?
Can you please post the EXACT error message (copy/paste), so that we can learn what it was substituting?
I can only guess that ASCL_MS1252 is a reference to Ascential's implementation of Microsoft code page 1252 (US English).
Is there any more information in the job log?
What are your DataStage NLS settings?
Can you please post the EXACT error message (copy/paste), so that we can learn what it was substituting?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 13
- Joined: Fri Apr 13, 2007 12:23 am
There are no other warnings other than "main_program: Invalid character conversion found converting to ASCL_MS1252, substituting."
We ran the job by putting sequential file stage instead of DB2 stage and it is running fine how many ever times we run the job with the same file.
If not DB2/UDB API stage which other stage is advisable?
We ran the job by putting sequential file stage instead of DB2 stage and it is running fine how many ever times we run the job with the same file.
If not DB2/UDB API stage which other stage is advisable?
-
- Participant
- Posts: 13
- Joined: Fri Apr 13, 2007 12:23 am