DSXchange

Hi, IMHO, The correct way of protecting and unprotecting your project is simply performing this action via DS Administrator. You'll need a production manager privilage defined to a group that is not the developer's group. the weak side of this is that you might need to unprotect your projects in ord...

Hi,
Yes it does happen some times
You'll need to retype your password and recompile.
This situation might also occur in schedualed jobs - reschedual them and in the schedual retype your parameters.

IHTH,

Hi and welcome aboard ,

Since such operations might need other clauses like table space and such, usually I tend to ask the DBAs to build me a SP performing the operation to their standards and invoke it as a before or after sql command or as a user defined sql.

IHTH,

Hi, From the top of my mind: Try to make seek jumps in intervals lower then 2GB perhaps it will work. you can use the additional ,1 in your seek statement to signify relative to current position. I'm not sure and it is not mentioned how seek works and 2GB limits of files seeked on. By the way why wo...

Hi,
Are you using the termination activity and using the send stop requests for running jobs inside the sequence?

Hi, Your design if slow by nature, your reading a row sending it ot the stp and catching exceptions this is not a quick task. you'll be better off loading the data to a temp table, then run the STP (that will read the table and give a result set) and populate your rejects table. A better way would b...

Hi,
AFAIK, you need to have a program like blat or similar to do it.
In case the notification activity doesn't support this you can always use a routine to run a command line execution of your Email application.

I hope I remember it right it has been a while since I worked on version 6

IHTH,

Hi And welcome aboard , You could read the data and in a transformer build a row foreach element (use Convert to change the comma to LF) to a seq file; So you should get something like: 1 US FR IT GR 2 GR BG After you have this simply read the file and store the number in a SV (stage Variable) build...

Hi,
Did you rebuild the stages or simply added the schema prefix to the existing table name?
If you didn't rebuild the stage try it and see if the error persists.

IHTH,

In any case reading frm seq files should be using varchar types regardles of real type since they are actually varchar (unless you have a fixed width file). using other types might cause you problems. having fields specified not null able means they can't be tested for null value sine they can't con...

Hi, what do you mean you see then only after the 3rd run? are you using client tools? is there a refresh interval? after the first run what happens if you run commit in the client? I've worked with MSSQL before and it worked fine. Perhaps we ovelooked something? can you give this scenario again in m...

Hi,
At this point it seems to be some issue with VC & NLS.
Trying to figure it out with support.
I'll post new info as it comes.

While when performing import/export it works fine.

Hi Craig, AFAIK, you must wrap the dsjob command with a script in order for ctrlM to get the status. So perhaps something went wrong in the script for some reason and the 141 code your getting is not even DS related? I'm currently using a customized version of Ken's script for running jobs via comma...

Hi,
What Unix are you using?
Usually there are file systems that can be defined to hold large files (over the 2GB limit).
So if you can do that I think your better off.

IHTH,

Hi, Other options include building views with proper column names hence bypassing the issue. Another option would be to change hte table definition and use the original column names with aliases (i.e. column name = column_name , and the derivation would be column name column_name ) just pick the bes...