DSXchange

Actually i need the command paths for "dsexport" or "dscmdexport" in my citrix machine i can't see these commands. Since i didn't have access to my the C drive from CITRIX i found it's very difficult to use this. Is there any other way i can import/export DS jobs from the UNIX se...

I'm working on Datastage 7.5 version which is installed on the citrix machine. There is URL for logging into citrix, after logging i can see all the DS client components and putty(UNIX component) on it. There is no remote desktop which we can see on the citrix box. I'm having lot of independent data...

i have cleared the status file and used clean up resources also but no success..

Hi Datastage Experts, I have a ran a datastage job sequence through "Autosys Utility" two days before which will trigger a datastage job(which do the loading into tables) , still the job is in running state. But in autosys the job status is showing as "failed", i have used the &q...

could you check with the "IsNull" Or "IsNotNull) function.. instead of the NullToEmpty or NullToValue...

let us know the output

Refer the docs for "dsimport" or "dscmdimport" command this two commands are used for importing the elements(jobs,table defns etc)

I have saved the table definition in datastage and it got saved in the repository. I want to list the column names present in the table definition from the command line. Is there any command which lists the field names of the table definition from the command line like dsjob ?? Please provide your i...

The function is WeekDayFromDate() which will give the day of the week, sunday is the default date -- the value is 0.

How about updating the design like this :- nested_cond ----> 3 o/p links(Each o/p link is having sequencer with ALL mode) Then one o/p link from 3 sequncers to a single sequencer(with ANY mode) followed by your next job activity stage. the overall design looks like this nested cond ----> 3 seqncers ...

Hi, I can provide a temporary solution this problem, may be some DS experts can give you better solutions than this. 1) first do vertical pivoting that's converting similar rows into one single row. e.g:- job,empno,ename,empno1,ename1 Manager,1000,aaaa,2000,bbbb Accountant,3000,cccc,4000,dddd Clerk,...

In one of my projects we have passed inputs as XML to the web service.

I think you also have to send XML as input. I suggest you ask your web service team for clarifications, like they will suggest you the expected input required for the web service.

It depend on your requirement. If your purpose is to just raise an exception and abort the job then go with the exception handler and terminator stage. Else if you want to do some other thing then disable the automatically handle activities that fail in properties tab and then use the terminator sta...

But i think it needs date to string conversions before doing that...
Or Is it implicit??

But sequential file stage by default runs in sequential mode, then why you need to constraint it on a single node?

Try this link too..
http://issaq-infomania.blogspot.com/