DSXchange

Ray, No luck... I tried with the syntax u gave.

Any other clue.

Hi I need to access some project info from the existing project. Meaning, lets say, I'm querying for category information in UV as below.. SELECT CATEGORY FROM DS_JOBS WHERE NAME='JobName'; I need to get the same information for the job which is there in different project. How do I query the differe...

Many thanks to everyone :D. I have achieved this in 2 way. One, added constraint to check appropriate DBMSCODE and used UtilityAbortToLog transform to abort the job. Second, added one more output link which will reject the record if appropriate DBMSCODE comes and AbortAfterRow is set to 1 in the con...

Hi

I'm using OCI to load data into oracle table. We have option "Treat warning message as a fatal error" to abort the job if any warning occurs. My question is, can i filter out only one warning (oracle error) as fatal and rest can be ignored?


Thanks in advance
Ahmed.

Hi While doing lookup using ODBC stage, we have defined primary SQL something like select a, b, c from tbl and the reference SQL is something like select * from (select a,b,max(c) from tbl where a=? and b=? and c < ? group by a,b) where rownum < 2 We are facing with performance issue (sometime back ...

Hi Prashant / Luk

What will happen if the data is like this:

x,a
y,b
z,c

Will i get the below result:

x,a,1
x,a,2
x,a,3
y,b,1
y,b,2
y,b,3
z,c,1
z,c,2
z,c,3

I guess Luk needs this than the above solution. Let me know.

Thanks
Ahmed.

Test it out urself. It will make 02:00:00

Its very simple add two more stage variable

SAddHours: HoursFromTime(STime) + SHours
SAddDate : If SAddHours > 23 Then DateFromDaysSince(Div(SAddHours,24),SDate) Else SDate

Output is SAddDate : " " : SAddTime

Hope this helps

Ahmed.

Lets say your input is DateIn = '2004-10-28 10:22:33' Following are the stage variables used: SDate : Field(DateIn," ",1) STime : Field(DateIn," ",2) SHours : 10 SAddTime : TimeFromMidnightSeconds(((HoursFromTime(STime) * 3600) + (MinutesFromTime(STime) * 60) + SecondsFromTime(ST...

Here is the usage of dscc utility Usage: dscc [@argfile] [/?] /h <value> [/o] [/u <value>] [/p <value>] <project> [/j <value>] [/r <value>] [/f] [/ouc] [/rd <value>] [/rt <value>] [/jt <value>] [/mful <value>] [/mfcgb <value>] @argfile Read arguments from a file. /? Show usage. /h <value> Name of Ho...

Hello Yamini

Try this out in the filter command:

sort -t "," -k 21,23 <Filename>

where "," is the delimeter and 21,23 is the column number from 21st to 23rd to be sorted.

Hope this helps

Ahmed

This error occurs generally if password is not correct. But since you said that, u also tried after resetting the password, some problem with the userid u r using. Check with the administrator.

Have you tried login to DS with different userid (with no admin rights)?

Ahmed.

Error messgage tells that PATH environment variable (which is set up in the $DSHOME/dsenv file) does not include the directory in which either or both of sed or dbx commands is found.

Check it out for the PATH variable and the files in appropriate path. If that is not there

Can you try adding $ORACLE_HOME/bin in LD_LIBRARY_PATH Restart DS after the change is done. Try your luck. Its working fine with me. export SHLIB_PATH=/usr/lib:/ascl/dsadm/Ascential/DataStage/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC/hotspot: $DSHOME/java/jre/lib/PA_RI...

Can you tell what was the error message?
Are you trying with environment variable or job parameter?