DSXchange

I am sure you can, even if it is via your original idea of a shell script/batch file.

If not, would you be able to have DS generate a log number in the same way the DB does?

And what a question indeed. To tell you the truth, I would probably go for two seperate streams, it just sounds (and probably looks) more manageable. I dont want to send you beating around the bush, and i might add I have not tested the following, but you are welcome to test what I propose... by cod...

hi James it sounds like a complicated way of doing things. If you have to use the stored procedure, then I would suggest you gather the required INPUT parameters for the stored proc by using parameters in a job control. This information (like start time, end time, process time) can be obtained by do...

Hi morney I fear that there is no way. (have you tried /* comments ?*/) If that does not work, then you could do what we are currently doing to aid documentation and that is to paste the SQL into the description of the stage. this would mean you could save all the comments you could possibly need.

I was afaid of that. now i just need to go back and insert the stage to the job. thanks ogmios.

Hi ogmios yes, the new line is generated in the SEQ stage, but i have an extra "line" of "data" after all my detail records are listed. i.e. col1|col2|col3|CR/LF dat1|dat2|dat3|[color=red]CR/LF[/color] <this is an extra record with nothing in, not even NULL> i want to omit the CR...

hi shrikanth problem 1: do you log into DS with the same user that is logged in on the windows server? when you select 'omit' the user currently logged on to the windows server is authenticated against DS. It might be that you are using a lower level security user to access key files that DS uses to...

Hallo all

Is there a way to omit the last new line character in the constraint of a transformer? I dont want to have to revert to scripts and/or SEQ stages to do this.

I have tried LINK.COL > 0 and LINK.COL <> @NULL, but no luck.

Hi guys

Im struggling to convert the following:
where Fis supposed to indicate a sign. I think DS expects a D or C for signed decimals, but what does it do in the case of a default allocation - in this case F.

any ideas..

Its very annoying when you try to open a job, get the annoying message 'locked by another user' agreed. 1stpoint, you'll need to get the developers off the jobs when you want to export/import, and i believe the only way is to ask them to get off the server jobs (ok, perhaps not the only way). a pos...

very simply, in BASIC you would code this algorithm open file start loop read record if detailRecord then write to output file close loop close file ok.. what happens here is that you loop within the file testing whether the detail record exists. This works if you have CR/LF because you're just test...

I don't think what dnzl has suggested will work

anupam; you pointed out something that i overlooked - file format. But, if there is a CR/LF at the end of the row, the header constraint should work; we were using this process before we started to validate the header and trailers.

In your transform, from the sequential file add this constraint: @INROWNUM > 2 (if header is first two lines) this will omit the header. The footer you can also ignore by adding something to the constraint: @INROWNUM > 1 and col1 <> '------' seems a dirty way of doing it though. you could put this i...

Hi lindie

Get an ODBC trace so that you can track whether the sql server is actually receiving input from datastage on unix. Is this problem only occuring on this one table?

weird.. as soon as i create the project as an unprotected project, it all goes through, no problem.

this is DS7.1r1 - i hope its no bug.

>>> the workaround now.. in administrator; unprotect project. then copy jobs to PRODUCTION. after this process, Protect the project again. <<<