DSXchange

Hello everybody I have one sqlserver table with an attribute type date i'm using a odbc stage to "insert rows without clearing" i'm suging a odbc stage to select a row i'm using a transformer just to match directly i'm getting errors: (1) [...]: DSD.BCIOpenW results of function SQLColAttri...

!!! thank you very much !!!

u can't imagine how much u've helped me !!! it works !!! just fine

:D

! hi ! I just want to do a simple thing: job1 - to know which file is in the directory (windows = dir vs unix ls) (i always know there is only one file in the directory, that being garanteed by another 3rd party application that generates a file which keeps changing its name automatically generated)...

! Hello ! sequnce.JobControl (@Job_Activity_5): Controller problem: Error calling DSSetParam(resultado), code=-4 [ParamValue/Limitvalue is not appropriate] What version are you on? If it's earlier to 7.5 then there are known problems while passing parameters within the Execute Command Activity stage...

thank you ,

but

B is not a file, it is an option for the dir command, for the result of dir to only use bare format (no heading information or summary), e.g lixeira.txt instead of all the information/overhead

thnxs

!hello! i built a sequence justa as simple as this: - 1st stage = execute command activity - command = dir - parameters = #directoria_saida# /B - 2nd stage = another sequence - parameter1 = 1st stage.$CommandOutput (string type) this always fails, the log being: sequnce.JobControl (@Job_Activity_5):...

We've changed our odbc from ascential informix into the newest ibm informix odbc driver 2.90.0000 2.90 TC3. Now we're getting warnings/errors where everything was ok, for instance: j_0505_0100_data_inicio_processo_20050914..altera_data.update_ctl_pro_exe: DSD.BCIPut call to SQLExecute failed. SQL st...

i've solved the problem using job control but i'd much prefer to solve it using the loop (start&end) as it would be a much more clean solution , so i'm trying it very hard ... i've tried to search for the list of possible delimiters and cannot get one which would work ... command = dir /B #path#...

i've tried to write a Sequence: - i use the a ExecuteCommand activity - - dir #path#\*.* - i then use a start loop - - delimited values = #Execute_Command_0.$CommandOutput# - - delimiter = CR/LF - i then use a job (jobA) which receives a parameter parametro - - in the sequencer i make parametro = Ex...

I will clarify this:

for each filename found in a given directory:
call a datastage job with a parameter = filename

thank you

i'd want to order a job (using datastage basic) for each file i'd find inside a directory (without knowing the filename or even the number of files inside the directory), how can i do it ?
thank you !