DSXchange

Invalid character fond converting string from code page UTP-8 to unicode substituting.

Data type is char.
Input is sequential file

Reason might be: any invalid character in input file like japnese,etc..

Solution please.

I did used remove duplicate stage for the records on which warning coming out. I used the same key column based on what data has been extracted or lookedup in lookup stage. Is there any possiblity of line break or any junk character into file. May be i will check data set data one more time.. But pl...

I did checked table data there were no duplicates hence using remove duplicate stage warning remains the same.

Any other resolultiion please...

So did this change is good sign to be implement or there is any other way to remove above warning.

As I dont want to return multiple rows for single line. or suggest

Recieved warning on ignoring duplicate entry at table ...no further warnings will be issued for this table. Solution: Made the one of the referance link in lookup stage for selecting multiple rows from link and warning has gone. Query: Is there any impact of data flowed from link after selecting mul...

Thanks it was resolved yerterday intself as coded again after removal of stages and link which has thrown the warning.

This is related to Parallel job.Gettting warning for lookup state column.
Checked Input/Output column and are same.Also its not speicfied as key column from source.

When checking operator-the view adapter has a binding for the non existent destination field:
Checked all ways but warning is not removing
e.g: took new stage and coded again
tick on column thrwoing warning complation didnt worked.
Mentioned column meta data is same.

Please let me know.

Please let me know how to handle multiple files in single job.
I have clicked on the option allow multiple instant.
Query:

I have two files coming to the input having different naming convension,and it need to be proceed in same job at a time.

How should i handle it at Datastage level

Before running query you have to check for UV command. You need to setup the datastage enviormental variable. And if there are multiple projects, you have to logon on those projects and then you can check the job specific properties as well.. One UV is set, you can query datastage tables to get the...

Search DSXchange. There is a recent (current) conversation about UNIX processes that belong to a DataStage job. The job itself does not exist in UNIX. The job itself is stored in database tables. ... there is datastage and unix connectivity.In version 8 we can seach the job.But in 7.5 suppose for e...

how to search the data stage job in unix..

kduke wrote:FTP will also get rid of these if you transfer ascii instead of binary. ...

ok will try this and let u all know...

between thanks.. but keep posting new ideas for the same

Hi,

We can remove the control m or special characters in UNIX scripts.. but
is there any way to remove the special characters coming in flat files from Datastage jobs?

Sainath.Srinivasan wrote:Or write one yourself as

Code: Select all

  If yourField < 0 Then yourField * (-1) Else yourField

...

or use field function to convert all negative sign to positve and then load into target