DSXchange

are you sure thats the reason, because the rest of my jobs are compiling, its just the sequence jobs that are giving me trouble.

Hi there guyz, The problem i am facing is that i am getting a compilation error which says --------------------------------------------------------------------------------- <JobSeqGenError> <Code>2017</Code> <Desc>XML parser error on input line 0: source='', reason='The system cannot locate the reso...

hi guys,

Is there any feature in DS to execute basic commands in seperate window in order to test the built-in functions.

or

Do we have to always design a job for this..?


for eg.,

Trim (" develop ") --->develop

Thanks
appreciate your time

thanks ray,
i had a feeling thats all that i need to do.
thanks again.

well, in the template i see in the general tab of job properties, in fulljob description something about the vc log, i am guessing thats what i am suppose to clear but go ahead and tell me how to clear the long description added by version control while promoting. thanks for your help ray...!

hi guys,
i am using a template of a previous job sequence and i need to clear the version control log before running the new sequence, how exactly do i do that?

Have checked that before. Thatts not the problem.

Hi guyz, I am doing a straight load from a sequential file to the database table (SQL server). There are 91387 rows in the sequential file. Its giving me 8 warning msgs. The msg goes like this " XTR_SrcBatSap_SOSD3002..TRF_ConvertDataTypes3: [Microsoft][ODBC SQL Server Driver]String data, right...

Are you creating the Hash files in the same job? Yes

Are your two large bunches of lookups and the transform in the same job? Yes

Are these all seperate jobs and you are landing to disk in between the jobs? NO

How big is your data? Avg sized 3mill rows

You will need to code a job sequence utility to automate the process.
regards

Gota go through DataStage basics.
What type of SCDs you want to implement?

Thanks both of youu.
In my table there are 3 values in which manga is not = null and the value 8 is not being still populated.

???

i have a routine that is working for one condition but not for the other. the piece of code is as follows RoutineName = 'EkbeAsnQty' Deffun DSRMessage(A1, A2, A3) Calling "*DataStage*DSR_MESSAGE" Ans = 0 Mange = 0 IF IsNull(Menge) = 0 Then IF (Vgabe = '6'! Vgabe = '8' ) THEN If Shkzg = 'S'...

You can do it in the transform stage itself. ie; convert it from EBCIDI to ASCII.