DSXchange

You will need to put the send mail as an after-job call to have it executed once per job; right now it will execute every row. The configuration of the DSSendMail() utility is done only through modificaton of the dssendmail_template.txt file and through the parameter list. Please take the time to re...

Scorpion, your SQL query (either the generated one or your user-written SQL) has invalid characters in it. Most likely you used a special character in a column name and didn't quote it appropriately. If you cut-and-paste the SQL query from your Oracle Stage into your query tool of choice (SQLPlus or...

This type of error can occur when some automated update package on your PC has installed some new or upgraded software and overwritten DLLs. This error might go away if you re-install your client (although whatever other package is out there might have problems).

antojj, you need to read the documentation on how to set up your mail environment in DataStage. Have you even looked at the template file? Think about it, you have told the DSSendMail from whom the mail is supposed to be coming but haven't told it other vital things such as recipient, subject and ev...

there are locks, this is the only reason that an UPDATE command will not return. Try doing a "fuser -fux SDKSequences" to see which processes have that file open. I bet you it will be more than 1.

I would go to TCL and enter the command "LIST DS_JOBS WITH @ID EQ {myjobname} JOBNO to get the job number, then look into the project subdirectory RT_BP{JobNo}. Or you can use the UNIX find command on the object "JOB.1912664994.DT.1386960595.TRANS3".

If it "hangs" then the record is locked by another process. While in the TCL environment do a "LIST.READU EVERY" and see if the there are any locks on the file's inode (you can see the inodes for SDKSequences in the project directory by doing a "ls -i" command. Perhaps you did an cntrl-c or even a k...

Battleboy,

could you perhaps expand on "It's not working", perhaps with an error message?
The command should work unless the SDKSequences hashed file does not exist or the user executing the command doesn't have sufficient access rights.

Check your transform "TRANS3" stage derivations. One of your derivations is doing a numeric operation on a column that does not contain numeric values. Usually a quick look at your derivations will show you the culprit; but if you feel like delving a bit deeper, you can look at your job's generated ...

Throws arms up in surrender

looks like a bug...

Chowdary, this subject has been handled in this forum several times before. Also, it might be a good idea at this point in time to revisit your self-assessment in your user profile. If you create two stage variables in the following order: ColAIsTheSameAsLastRow IF LastColA = In.Col THEN 1 ELSE 0 La...

I thought that it was used to cap the number of sessions; isn't that the program used to validate creating another connection? That's why I said that is show the number of licenses that DS thinks is in use. I'll need to check up on that.

I'm not at a DS installation right now, but I believe that the filter setting is global for the director and not local to a job; so you'll need to change your filter values to the higher number when viewing the one job. Have you tried setting the filter while in the log view for one job and seeing i...

Hi , ...When I logged into the corresponding project through dssh ( UV environment ) , I found that 1 license is being utilized otherwise I am getting the below message...Phani How did you find this out in dssh? The correct display of the number of licenses that DataStage thinks are in use are disp...

Bala, you've identified your problem. You've declared the first_name column to be of fixed length of 16, yet your data has this column as a varchar column. You can get away with this in DataStage Server, but PX is very picky about using correct datatypes. You will also need to change the last name t...