DSXchange

Hi, i have an requirement to capture the list of param values in a job , i tried with the function Ans = DSGetparamInfo(seq_TMW_MID_INVENTORYHIST_ONHAND, "AUDIT_FILE_NAME",DSJ.PARAMDEFAULT) in a routine window but its not compiling its throwing an warning C ompiling: Source = 'DSU_BP/DSU.C...

Hi, When i trying to export the datastage jobs through linux command prompt i got a below error. ./istool export -dom DSTAGEDEVSYS01 -u nd65 -p nd65gzork -ar test.dsx -ds 'DSTAGEDEVSYS01\MANHATTAN\Jobs\ARCHIVE_AND_PURGE_DATA\ODS_MID_DISTRO_01_ARCHIVE.qjb' ERROR: unable to connect to ISF server: DSTA...

How to get the list of parameter values that used in a job.
dsjob -lparams command gives the only the parameter not giving the default values.

Any one have an idea how to get the parameter name and default value.

Thanks ray,

I just wanted to generate a report which contain list of the job names and folder where the pivot stage was used.
can i get this info by using above ds command

Hi All,

I have an small requirement to identify the list of the stages that used in a jobs across the project.

is there any way to achieve this ?? instead of doing the manual process, since i have a more than 5000 jobs.


Thanks in advance

Thanks Arndw, my table names were not hardcorded .
can i find this information from metadata work bench

Hi, I have an requirement like to identify the list of tables and sequential files that used in a datastage jobs across the project. for example TableA was used in a five jobs out of five this table was used as a source in two jobs , used as a target in one job , used as reference in two jobs. Is th...

Yes , you are correct NULL fileds will be filtered with ISNULL function and blank strings are filtered with Len(trim(string)) = 0.
But your source is an flat file so you cannot see the null values in a flat file. to filter the null values in a flat file you should check Len(trim(string)) = 0.

Hi, I have an unix command its executinf fine in unix editor but when i tried to execute same command in datastage through execute command activity its throwing below warning SH: -c: line 0: unexpected token 281 in conditional command SH: -c: line 0: expected `)' SH: -c: line 0: syntax error near `(...

Thanks ray,

Is ther any way to check
if day is not in (sat,sun) and time between (08:00 20:00)
from current timestamp vaue in datastage.

Hi,

I have an requirement like my jobs will execute on hourly basis incase of job getting abort email alert needs to be send , this alerts should be send during non business hours only.
could you please sugestme ho to restrice this in datastage...

Thanks in advance...

Hi any one could help me to get out this scenario with out using tranformer stage ..

ource
------
A,A1 A2 A3,B
z,Z1 Z2 ,C
Y,Y1,D

o/p
---
A,A1,B
A,A2,B
A,A3,B
Z,Z1,C
Z,Z2,C
Y,Y1,D


Thanks
in advance

Hi

Can we filter the data based on length of a field using filter stage ???

Thanks kryton ..

Hi, I need a some solution to achieve the below output. my source data like Hyderabad-HYD,scb New Delhi,NDA,Ghs O/p --- Hyderabad New Delhi Here i need to fetch only the before first delimiter characters, it should be ignored after the -/, characters. i have some solution to handle this 1)find the c...