DSXchange

TeraUtils:DB Call Failure(success check) Info = 0, Code = 2801, Message = Duplicate unique prime key error in TDB.SIM_CARD_SUBSCRIPTION_HIST. There are some issues with the database stages.. specifically with DB2. Job was not aborted even if there are fatal error messages in the director. Those mes...

I have again checked in the unix the file isgood only..no problem with the data...even the columns are properly defined with data types..... what could be the error....? If you are getting the ORA-00911, it is quite obvious that you are having the invalid charaters in your data, or they are introdu...

Yes..as it said it really depends on the various factors.. However doing the changes in quries is better in one of the aspect as it will avoid more i/p operations. It will give the DS only the formated data. Otherwise it will just read and give all the data to DS where DS needs to perform the change...

Decimal with floating scale is converted to the dfloat datatype. That is why it is giving the error of truncation. One of the solutions can be :- 1. Use modify stage to modify the datatypes. 2. Check what exactly the data type is required after the copy stage. whether you are just processing it or i...

ORA-00911 is due to invalid character.. 1.Check if there are any Varchar columns and the characters which are appended by the DS. 2. As you are saying you are trying to update the data, which columns you are tying to update and which columns you are using in where clause ? 3. 'Data is clean only' Wh...

If hard coding is working and the parameters are not working means there are some issues with parameters only..

1.Check your parameters properly.
2.Check if there is any space of path name which you are passing is correct.

Hope this helps.

Check this :-

viewtopic.php?p=315116&highlight=#315116

Hope this helps..

Try this design.. Seq file - > Transformer => funnel - > seq. file From Transformer stage there will two output links. You can put constraint depending upon your requirement, so that two records will pass on the two links and funnel will collect those records and final sequential file will contain t...

if [[ `awk 'END{print NR}' /RejectFiles/Extractrejectfile.csv` -gt 1 ]] then uuencode /RejectFiles/Extractrejectfile.csv Extractrejectfile.csv|mailx -s Extract Errorfile xyz@hotmail.com else echo "File is empty" fi Else contains the 'file is empty'.that means it should be containing any r...

Can you give us more details?

Which stages you are using and how you are making 2 records of one record ?

There is no rule as such there should be same number of input and same number if output..otherwise row generater might not have worked at all

If the file names are parameterized then there is one way to find it out by using the dsgetparaminfo !

You need to take each charater of your string and then convert it to in ascii and check the values of it.

You can get the logic in one of the post how to break the string into the characters and converting it into the ascii...

If you are just checking the file is empty or not, why dont you just try to use -s flag..
I guess that could also help the remove the error which you are getting.. I suspect it is due to awk which you are using in the if loop.

L -> | M L -> | Max | M L -> | Max | M L - > L :- Job takes minimum time... M :- Medium time Max :- Max time.. If you can have a design to start the jobs which takes less time simultanously and the job which takes the long time can run when there is less processing to do ! It will help in such way t...

Hi..

What is the datatype of the field that you are checking for..

And if it is passing through not null constraint, it seems there might be some not null values can be there in the field..may be spaces..

worth checking i guess !