DSXchange

here is the situation, take is as an example. the NAME is an attribute and its datatype is VARCHAR(50). from the source file for few records under the name attribute thai characters are coming, since we are not using NLS, it will be consider as two byte which will try to get instered into table unde...

As i said earlier, we are not using NLS. in the name attribute if those characters are coming then it is a problem. example - NAME - VARCHAR(50). If this non readable character is coming in the name attribute then the requirement here is to read and count how many characters are coming as non-readab...

It is based on your requirement. can you narrate what is your requirement. so that it wil be useful for the boarders to write the correct answers / solutions to your queries.

It is based on your requirement. can you narrate what is your requirement. so that it wil be useful for the boarders to write the correct answers / solutions to your queries.

You can pass on the filename as a parameter to the job and get the run date and time you can format it according your format. concatenate those filename and run date and time, you can get the dynamic filename.

Ok Tks. how will i count how many characters come in a record and also in an attribute. Assume if hexadecimal value itself is coming, how will you conert that and count those.

1. what type os rejection it is? is that due to the data comes in source or while performing the validation rule in your requirement. If data you are getting in the source not matches with the job developed those general warnings and errors you can get it in the reject link. whereas if your requirem...

I hope that is not a jung characters, as i said earlier, it is not readable characters. example, if the thai characters coming in the name attribute, without using NLS, you can read those characters, so how we can identify those characters which are not undertandable by english one.

How to identify the junk (non-reable or non-printable) characters in a record, I need to find it out in process of loading the records from source to target. is there any function for that.


tks.

tks guys.

Its working............now.....

I tried using schema, schema is record {record_delim='\n', record_length=fixed, delim=none} ( name:nullable string[13] {width=13, null_field=' '}; account:nullable int32 {width=7, null_field=' '}; amount:nullable decimal[23,3] {width=23, null_field=' '}; status:nullable string[1] {width=1, null_fiel...

tks. got it

I hope only the few content we can read, rest is viewable only for the perimium members, once can you pls post the URL alone

have you mentioned anything after "If you.........." in your reply, if so, i am unable to read it..............

Have opened two jobs in a session. both jobs are not compiled, just got imported. the datatstage got timedout. when I tried to open the job, i am getting a message like the job is being accessed by another resource. I tried in director using clean up resource, then killed the session in the unix the...