Search found 437 matches
- Tue May 13, 2014 12:57 pm
- Forum: General
- Topic: Routine Output to pipe delimited file
- Replies: 3
- Views: 3195
Thanks Ray, I tried with SUPRESS HEADER option as you mentioned, but I'm receiving an error message, so I commented the SUPRESS COLUMN HEADING statement, so I tried with unix sed command and its working fine. Please let me know if SUPRESS statement is wrong. Ans=0 PathFileName = FileDir:'/':fvdsjobn...
- Mon May 12, 2014 9:47 am
- Forum: General
- Topic: Routine Output to pipe delimited file
- Replies: 3
- Views: 3195
Thanks Ray, It worked after I used convert function. Ans=0 PathFileName = FileDir:'/':FileName * OpenSeq File or Create File OpenSeq PathFileName To FileVar Else Create FileVar Else Abort fvFilterDate = fvdate * Set the Terminal Width wide to show more characters Call DSExecute('UV','TERM 170',rVal,...
- Fri May 09, 2014 2:12 pm
- Forum: General
- Topic: DS_AUDIT issue with group by clause
- Replies: 1
- Views: 1747
- Fri May 09, 2014 10:13 am
- Forum: General
- Topic: DS_AUDIT issue with group by clause
- Replies: 1
- Views: 1747
DS_AUDIT issue with group by clause
Hi All, I have a server routine to get the auditing information like job name, creator and modifer name and last last modified timestamp for a particular date. I'm using below Transform function. But I'm getting an error message DataStage/SQL: Individual column specifications are illegal with a sing...
- Fri Jul 26, 2013 1:59 pm
- Forum: General
- Topic: Encrypted password for dscmdimport.exe
- Replies: 2
- Views: 2276
Hi, In 8.7 version, I found couple of files with encrypt.bat in documentation install_root\InformationServer\ASBNode\bin\encrypt.bat install_root\InformationServer\ASBServer\bin\encrypt.bat When I checked in my local drive using 8.5 version under C:\IBM\InformationServer\ASBNode\bin, I'm not able to...
- Fri Jul 26, 2013 9:19 am
- Forum: General
- Topic: Encrypted password for dscmdimport.exe
- Replies: 2
- Views: 2276
Encrypted password for dscmdimport.exe
Hi , I'm using dscmdimport.exe command to import the datastage jobs and below is the parameter that is setting up the datastage credentials SET DParams= /D=%HostName% /H=%ServerName% /U=%userid% /P=%password% %project% My question is, is there a way to pass the encrypted password for the P parameter...
- Thu Apr 11, 2013 9:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transform Function
- Replies: 4
- Views: 3431
- Tue Apr 09, 2013 10:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transform Function
- Replies: 4
- Views: 3431
Transform Function
Hi All, I'm trying to find the category name for a particular job by a transformer function. Below is the code Ans = "" svName = "pxHtttlemp" svTrimName = Trim (svName,".","A") svFMName = Trim (svTrimName,@FM,"A") *Get list of jobids that contains a ...
- Fri Dec 07, 2012 9:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Repeating Sequences in XML input stage
- Replies: 6
- Views: 4323
Hi Ernie, The problem is with the data type that I used when I imported the meta data from XML Table definitions, for numeric fields like PHONE Number it imported as decimal (10), I changed to varchar (10) and made the Key column as Phone type code and I'm getting all the record's with out any dropp...
- Thu Dec 06, 2012 11:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Repeating Sequences in XML input stage
- Replies: 6
- Views: 4323
Hi Ernie, Thanks for the reply. Here is the issue is not with repeating element, but this issue is due to repeating sequence in XML. I tried making PHONE_TYPE_CODE as a key column with repetition element required option selected . But still getting the same issue only getting one record. I think I n...
- Thu Dec 06, 2012 9:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Repeating Sequences in XML input stage
- Replies: 6
- Views: 4323
Repeating Sequences in XML input stage
Hi, I'm working on XML file that has the repeating sequence. Please see below <?xml version="1.0" encoding="UTF-8"?> <MEMBER_EXTRACT> <REC_CNT>1</REC_CNT> <MEMBER> <MEMBER_ID>111</MEMBER_ID> <MEMBER_PHONE> <PHONE_TYPE_CODE>WORK</PHONE_TYPE_CODE> <PHONE_TYPE_DESC>Work/Office</PHON...
- Sat Sep 22, 2012 8:24 pm
- Forum: General
- Topic: dssh shell
- Replies: 2
- Views: 2245
- Sat Sep 22, 2012 9:45 am
- Forum: General
- Topic: dssh shell
- Replies: 2
- Views: 2245
dssh shell
I'm trying to invoke dssh shell from the command prompt and I'm getting below messages. bash-3.2$ This directory is not set up for DataStage. -bash: This: command not found -bash-3.2$ Would you like to set it up (Y/N)? 0. Ideal compatibility 1. IN2 compatibility 2. Prime Information compatibility 3....
- Sun Aug 19, 2012 7:17 pm
- Forum: General
- Topic: Routine DSJ LINKROWCOUNT Error
- Replies: 11
- Views: 5172
- Fri Aug 17, 2012 4:33 pm
- Forum: General
- Topic: Routine DSJ LINKROWCOUNT Error
- Replies: 11
- Views: 5172
I'm getting current job name and I need to get the proper output from DSGetLinkInfo function, even if the job handling section is wrong since the if clause will not be executed and goes directly to DSGetLinkInfo function, but it is always throwing -1 output . I don't think it is happening due to bad...